Thread

Hello

After the update to latest version, some links stopped working ({site_url} is not being parsed) causing the following error:
The URI you submitted has disallowed characters.

Also after the update when i click on any of my MSM domains, it is adding a www at the beginning of the domain, and I don’t want that. 

Version & Notes: EE v2.5.3 - Build: 20120911 / Forum 3.1.9 / MSM 2.1.4 / Removed index.php

Anyone?

Hello Kaori,

I am sorry to hear you are running into this problem.

Would you mind showing me what you htaccess file looks like? Can you move that aside for testing?

In your Control Panel under General Configuration - do you have www used for “URL to the root directory of your site”?

Please let me know.

Thank you,

Hello Shane

I have noticed {site_url} is not working on one of my channels, but keeps working on my other channels / templates.

My Htaccess

RewriteEngine on
           
# Everything else to the EE controller
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.+)$ /index.php?/$1 [L]    

AddType video/ogg ogv 
AddType video/mp4 mp4 m4v 
AddType video/webm webm

I have already fixed the second problem (www added to urls) during the weekend.

Thanks

Hi Kaori,

It’s not working for one channel? That is really odd.

Can you please check the Channel Preferences for this channel against one that is working. In particular “Path Settings”.

Please let me know what you find.

Cheers,

I checked two of my channels and both have the exact same settings.  On one of them {site_url} works and on the other one it doesn’t.

Attached: Path Settings Image for the problem channel

Hello Kaori,

I would like to get in a take a look.

Please be on the lookout for an email from EllisLab.

Cheers,

Ok, I replied to the email. Thanks

Hey Kaori,

Thanks!!!

Hey I wanted to know how this was going?  Can I continue working on my site or you recommend to wait until this problem has been looked into?

Hello Kaori,

I see that your are in private support. I let Kevin know you were looking for an update on the status.

Cheers,

Hi there,

I am trying to update a site from 2.1.3 - 2.5.3 and I am also finding that {site_url} is not being parsed.

I have had a look at the channel paths and changed them to see if it would make a difference but nothing.
Some channels work and some don’t as well.

I also have a channel SQL error which I am not sure is related but has also happens on some pages.

Unknown column 'wd.field_id_41NOT' in 'where clause'

SELECT DISTINCT(t.entry_id) FROM exp_channel_titles AS t LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_channel_data AS wd ON wd.entry_id = t.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id INNER JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id INNER JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1349866959 AND (t.expiration_date = 0 OR t.expiration_date > 1349866959) AND t.channel_id = '45' AND exp_categories.cat_id = '3' AND t.status = 'open' AND ( (wd.site_id=1 AND wd.field_id_58 LIKE "%No%") )AND ( (wd.site_id=1 AND wd.field_id_41NOT LIKE "%upgrading%") AND (wd.site_id=1 AND wd.field_id_41NOT LIKE "%h3%") )ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc LIMIT 0, 100

Filename: modules/channel/mod.channel.php

Line Number: 2736

As you can see from the SQL code the “wd.field_id_41” just needs a space after it.

Have you got any ideas on trouble shooting this? The main thing at the moment is the {site_url} as that may end up fixing the SQL issue.

Let me know if I need to create a new thread.

Cheers
Steve

I fixed the SQL error by changing the modules/channel/mod.channel.php file at line 1149 to have an extra [ . ’ ’ ] at the end.

Changed from:

. ' AND wd.field_id_' . $this->cfields[$site_id][$field_name]

TO

. ' AND wd.field_id_' . $this->cfields[$site_id][$field_name] . ' '

That is what is also put on like 1142 but for some reason missed on line 1149.

EDIT: this has already been reported as a bug/fix of V2.5.3 and will be in the new release https://support.ellislab.com/bugs/detail/18228

My issue with the {site_url} within links was fixed once I synchronized all my folder locations.

Just wanted to let the people who are following this error know that Kevin and the team fixed this on my install.  I want to thank Kevin, Shane and the team for their help.

More information can be found here: https://support.ellislab.com/bugs/detail/18287