
12-29-2006, 01:34 PM
|
|
|
Join Date: Dec 2006
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I've made a mistake I believe. I think that I selected all forums to not display the tags, thinking I was enabling tags on them. So I then went and tried to reupload the xml file via the mange products option and I got the following error
-------------------------
Quote:
Database error in vBulletin 3.5.4:
Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Zoints Thread Tags', 'admin_options_processing', 'if ($oldsetting[\'varname\'] == \'zointstags_disable_forums\')\r\n{\r\n $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] = array_filter(array_map(\'intval\', $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]));\r\n # verify existence of forums\r\n foreach ($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] as $key => $forumid)\r\n {\r\n if (!isset($vbulletin->forumcache[$forumid]))\r\n {\r\n unset($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']][$key]);\r\n }\r\n }\r\n \r\n if (count($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]))\r\n {\r\n $vbulletin->input->clean_gpc(\'p\', \'zointstags_auto_delete_invalid_tags\', TYPE_BOOL);\r\n if ($vbulletin->GPC[\'zointstags_auto_delete_invalid_tags\'])\r\n {\r\n # get threadids\r\n $threadids = array();\r\n $_threadids = $vbulletin->db->query_read(\"\r\n SELECT DISTINCT thread.threadid FROM \" . TABLE_PREFIX . \"thread thread\r\n LEFT JOIN \" . TABLE_PREFIX . \"zoints_tag zoints_tag ON(zoints_tag.threadid = thread.threadid)\r\n WHERE zoints_tag.tag IS NOT NULL\r\n AND thread.forumid IN(\" . implode(\',\', $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]) . \")\r\n \");\r\n while (list($threadid) = $vbulletin->db->fetch_row($_threadids))\r\n {\r\n $threadids[] = $threadid;\r\n }\r\n \r\n if (count($threadids))\r\n {\r\n $vbulletin->db->query_write(\"DELETE FROM \" . TABLE_PREFIX . \"zoints_tag WHERE threadid IN(\" . implode(\',\', $threadids) . \")\");\r\n # also delete tags from zoints\r\n $bits = array();\r\n foreach ($threadids as $id)\r\n {\r\n $bits[] = \"($id, \" . TIMENOW . \")\";\r\n }\r\n $vbulletin->db->query_write(\"REPLACE INTO \" . TABLE_PREFIX . \"zoints_tag_update (threadid, dateline) VALUES \" . implode(\',\', $bits));\r\n }\r\n }\r\n }\r\n \r\n $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] = serialize($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]);\r\n}', 'zointstags');
MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Friday, December 29th 2006 @ 08:31:36 AM
Script : http://stepinthezone.com/forum/admincp/plugin.php
Referrer : http://stepinthezone.com/forum/admin...?do=productadd
IP Address : Mp ip
Username : My username
Classname : vb_database
|
How can I fix this? How can I reinstall?
|