SQL errors after upgrade

[trident]

Upgraded to latest beta version on local pc yesterday. All seemed ok regarding the database and conversion.
Did the upgrade on the server last night and sql error flagged up when database converted.
The message was something like:
-------------------------------------------------------------------------------------------
Error
SQL query:

"1";


MySQL said:

#1064 - 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 '"1"' at line 1

---------------------------------------------------------------------------------------------
I have since done a back up of server DB, installed it on local pc and checked DB on my loacal pc using wamp. Get the above message.

We have also noticed several iages are now missing from items that were definitely there before upgrade.

Also, i have now noticed errors being reported by Google with Sitemap. Checking the file i noticed problems against each item - example below:
http://www.budgetcctv.co.uk/img/p/10-50-large.jpg
<link>http://www.budgetcctv.co.ukhttp://www.budgetcctv.co.uk/10-vr-fixed-dome.html</link>

It is putting the URL against each item twice.

Any ideas how to get out of this problem?

Repair SQL - not sure how
Revert to previous DB - if so, how?

Any advice/assistance much appreciated.

Andrew

[azurshop]

Bonjour,

Je viens d'ugrader ma version de Prestashop (1.1.0.5 ==> 1.2.0.8) et j'ai voulu modifier simplement modifier un produit.

Après validation de la modification, j'ai le message suivant qui s'est affiché :
____________________________________________

Array
(
[0] => 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 '' at line 1


[1] => Array
(
)

)


END

____________________________________________

Le problème que je rencontre ressemble donc étrangement aux erreurs constatées par d'autres personnes qui ont fait l'upgrade aussi.

Pour information complémentaire, je suis donc en Prestashop V1.2.0.8., mon hébergeur est 1&1;, la version de base de données est MySQL5.0, et j'utilise PHP 5 également.

Par contre, je ne sais pas si vous avez déjà essayé d'utiliser le générateur htaccess... en ce qui me concerne, le back office à planté aussitôt et la boutique n'était plus accessible. J'ai dû remettre l' htaccess de l'ancienne version de la boutique pour le tout remarche.

Merci de votre aide.

Azurshop