mysql seo urls path error

[slic535]

i updated my site yesterday and when i went to myphpadmin i was unable to push the browse button on anything. i mentioned it to the hosting company and am not sure if they did something on their end to make this happen. after i updated my site it seemed to run better and i had no errors showing up. now i am getting an error in the system error log. i am using 5.2.4 and tried to change my signature but it wont do it for some reason.

 

File: [seo.class.php] Line: [228] "SELECT * FROM `store1CubeCart_seo_urls` WHERE store1CubeCart_seo_urls.path ! 'include!s/content/categories0' ;" - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! 'include!s/content/categories0'' at line 1

[bsmither]

That is weird. My best guess is that someone entered that as the friendly URL. Or an edit you made accidentally creates links with this path.

[slic535]

i also get these as i thought that one was repeating but after i look at the rest they are different. they are

 

File: [seo.class.php] Line: [228] "SELECT * FROM `store1CubeCart_seo_urls` WHERE store1CubeCart_seo_urls.path ! 'include!s/orderSuc_cess' ;" - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! 'include!s/orderSuc_cess'' at line 1

 

 

File: [seo.class.php] Line: [228] "SELECT * FROM `store1CubeCart_seo_urls` WHERE store1CubeCart_seo_urls.path ! 'include!s/boxes/randomProd_' ;" - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! 'include!s/boxes/randomProd_'' at line 1

 

 File: [seo.class.php] Line: [228] "SELECT * FROM `store1CubeCart_seo_urls` WHERE store1CubeCart_seo_urls.path ! 'include!s/accou_t' ;" - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! 'include!s/accou_t'' at line 1

 

File: [seo.class.php] Line: [228] "SELECT * FROM `store1CubeCart_seo_urls` WHERE store1CubeCart_seo_urls.path ! 'include!s/boxes/0confirmed' ;" - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! 'include!s/boxes/0confirmed'' at line 1

 

File: [seo.class.php] Line: [228] "SELECT * FROM `store1CubeCart_seo_urls` WHERE store1CubeCart_seo_urls.path ! 'include!s/boxes/new_sletter' ;" - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! 'include!s/boxes/new_sletter'' at line 1

[bsmither]

Those look very much like CC3 folder names with a part of CC5 function names.

 

I wonder where these links are appearing in your store.

 

Or maybe, if you have built a sitemap, the links are coming from Google.

[Dirty Butter]

I just tested both sites with no obvious problems. I sometimes get urls showing up in our Google Webmaster Tools that are non-seo looking links. I guessed that my host hiccups, as they always go away in the Google warnings without my doing anything.

[Al Brookbanks]

Hi All, 

 

I would say I have upgraded a good 300 stores now and not come across this issue. I think bsmither is right about old files and folders. I'd suggest restoring the old version then upgrade again. Follow the upgrade instructions to the letter and make 100% sure the files and folders it says must be deleted are.