Support ⇒ Upgrades :: Archives ⇒ [fixed] 9.2 RC1 sql syntax error / undefined method escape_s :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexUpgrades

Archived ⇒ [fixed] 9.2 RC1 sql syntax error / undefined method escape_s


NanoCaiordo wrote
This confirm a smooth upgrade Smile


i'm trying to upgrade cms 9.1.2.1 wiht this new one, an i have problems by upgrading my sql db, error this error that... Evil or Very Mad

On /install.php? While executing query "ALTER TABLE cms_bbposts ADD df_varbin_tmp VARBINARY(17) NULL DEFAULT NULL" the following error occured: Duplicate column name 'df_varbin_tmp' In:

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


On /install.php? While executing query "UPDATE cms_bbposts SET df_varbin_tmp=0x5079273f WHERE poster_ip='Py'?/'" the following error occured: 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

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


@IgorMM: You had an error, then you ran the installer again and you got the duplicate column name error.

After that you used a backup and had the syntax error.

Is this what happen?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


hi i run the upgrade a few times triing to fix the errors that are showing.

now this error shows
On /staro/install.php? While executing query "UPDATE cms_cpg_comments SET df_varbin_tmp=0x533f274d WHERE msg_hdr_ip='S?'M/'" the following error occured: 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 'M/'' at line 1

and i had problems with poll nad unthers sql db tables.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


I've been testing this for a while on a big user and forum data, other users upgraded with no issues and no one of them had this problem, what a bad luck!

Bug is there and its now fixed, try RC2 over a backup.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


allmoste with every table the same eror show with rc1.
i'm now uploading rc2 we will se is the problem fixed Smile
thx for the help for now Smile

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


I get this error while installing RC2 with a backup database..

Fatal error: Call to undefined method sql_mngr::escape_string() in /home/content/g/a/u/gaurav1311/html/i/includes/db/mysql_mngr.php on line 241

{ Oversize Sig }

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.33/5.0.45/5.1.4/9.1.2.1


webhax wrote
I get this error while installing RC2 with a backup database..

Fatal error: Call to undefined method sql_mngr::escape_string() in /home/content/g/a/u/gaurav1311/html/i/includes/db/mysql_mngr.php on line 241


me to.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1

All times are UTC