I am now getting this error when I re-install a mod that I have used this with:
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
UPDATE navigation SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
WHERE name = 'link_nzc5_955' AND NOT (state & 2);
MySQL Error : 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 name = 'link_nzc5_955' AND NOT (state & 2)' at line 4
Error Number : 1064
Request Date : Saturday, June 2nd 2012 @ 01:46:06 AM
Error Date : Saturday, June 2nd 2012 @ 01:46:10 AM
Script : http://www.iamgrumpy.com/forums/admincp/apm_product.php?do=productimport
Referrer : http://www.iamgrumpy.com/forums/admincp/apm_product.php?do=productadd
IP Address : xxx.xx.xx.xxx
Username : Boofo
Classname : vB_Database
MySQL Version : 5.5.22-cll
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]/packages/navmanenhancements/admin.php on line 47
#3 NavmanEnhancements_Admin->__destruct() called in [path]/admincp/apm_product.php on line 2571
#4 install_product() called in [path]/admincp/apm_product.php on line 2571
If I remove the install code for your mod in the xml file, then it installs fine although there are things missing.