Bug SQL Error (1064) during installation

[Draffi]

Hi!

Today i want to install the DBT-A&A AddOn in my working-Forum. Like i was ever doing, i test this BEFORE in XAMPP-Test ground with an actual backup of my SQL-DB.

When i was purchasing the mod, all was working fine in XAMPP (was a clean install from vBulletin), but now the Add-on importer stops at:

Updating Version Number To: 1.1.0

Altered Table: vbs_dbtech_vbactivity_pointslog
Altered Table: vbs_user

And brings me an SQL-Error:

Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:

UPDATE vbs_user
SET dbtech_vbactivity_pointscache = 44662.7,
WHERE userid = 2;

MySQL-Fehler : 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 'WHERE userid = 2' at line 3
Fehler-Nr. : 1064
Fehler-Zeit : Friday, 19.10.2012 @ 23:01:28
Datum : Friday, 19.10.2012 @ 23:01:45
Skript : http://localhost/fftest/admincp/plugin.php?do=productimport
Referrer : http://localhost/fftest/admincp/plugin.php?do=productadd
IP-Adresse : ::1
Benutzername : #CHANGED_FROM_ME #
Klassenname : vB_Database
MySQL-Version : 5.1.37

Stack Trace:

#0 vB_Database->halt() called in [path]\includes\class_core.php on line 426
#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 444
#2 vB_Database->query_write() called in [path]\dbtech\vbactivity\install\110.php on line 77
#3 require_once([path]\dbtech\vbactivity\install\110.php) called in [path]\dbtech\vbactivity\includes\class_install.php on line 130
#4 DBTech_Install::install() called in [path]\includes\adminfunctions_plugin.php(1174) : eval()'d code on line 2
#5 eval() called in [path]\includes\adminfunctions_plugin.php on line 1174
#6 install_product() called in [path]\admincp\plugin.php on line 1751

Do you have an idea?

Thank you in advance

D.

 

[Fillip H.]

If you re-download the mod and re-upload /dbtech/vbactivity/install/110.php it should work for you now

 

[Draffi]

Thank you - but not working, sir...

stopped in the same situation.

DB-Error:

Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:

UPDATE vbs_user
SET dbtech_vbactivity_pointscache = '44662.7',
WHERE userid = 2;

MySQL-Fehler : 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 'WHERE userid = 2' at line 3
Fehler-Nr. : 1064
Fehler-Zeit : Saturday, 20.10.2012 @ 00:20:39
Datum : Saturday, 20.10.2012 @ 00:20:56
Skript : http://localhost/fftest/admincp/plugin.php?do=productimport
Referrer : http://localhost/fftest/admincp/plugin.php?do=productadd
IP-Adresse : ::1
Benutzername : ##CHANGED##
Klassenname : vB_Database
MySQL-Version : 5.1.37

Stack Trace:

#0 vB_Database->halt() called in [path]\includes\class_core.php on line 426
#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 444
#2 vB_Database->query_write() called in [path]\dbtech\vbactivity\install\110.php on line 77
#3 require_once([path]\dbtech\vbactivity\install\110.php) called in [path]\dbtech\vbactivity\includes\class_install.php on line 126
#4 DBTech_Install::install() called in [path]\includes\adminfunctions_plugin.php(1174) : eval()'d code on line 2
#5 eval() called in [path]\includes\adminfunctions_plugin.php on line 1174
#6 install_product() called in [path]\admincp\plugin.php on line 1751

 

[Draffi]

Somebody an idea?

 

[Ozzy47]

Fillip H. will get back to you as soon as he can, it is now 3am where he is, so I would assume he is sleeping.

 

[Fillip H.]

Same procedure again, another fix released

 

[Draffi]

My "Customer Area" on your site is gone !!! Shows nothing!

 

[Fillip H.]

Fixed

 

[Draffi]

Thank you!

And...

Thank you...! Working in XAMPP so far. In some hours i will install this Add-on in my working Board (Hope you have not so much things to do, after this...)

Great Support here!