View Single Post
  #786  
Old 12-13-2006, 02:45 AM
BadRobot BadRobot is offline
 
Join Date: Aug 2006
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

When I go to upload the XML file I get this Error

---------------------------------------------------------------------

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', 'vbimghost last 5 images - profile', 'member_complete', '$rec = $vbulletin->db->query_read(\"\r\n SELECT imgid,imgfile,thumbname,imgwidth,imgheight,imgdate \r\n FROM \".TABLE_PREFIX.\"vbimghost\r\n WHERE userid=\'$userinfo[userid]\' and imgprivate=\'0\'\r\n order by imgdate DESC\r\n LIMIT 5\r\n \"); \r\n\r\n$count = $db->num_rows($rec);\r\n\r\n$rec2 = $vbulletin->db->query_read(\"\r\n SELECT count(*) mark\r\n FROM \".TABLE_PREFIX.\"vbimghost\r\n WHERE userid=\'$userinfo[userid]\' and imgprivate=\'0\'\r\n \"); \r\n$row2 = $vbulletin->db->fetch_array($rec2);\r\nif ($count){\r\n while ($row = $vbulletin->db->fetch_array($rec)) {\r\n $vbimghost[\'id\']=$row[\'imgid\'];\r\n $vbimghost[\'path\']=$vbulletin->options[\'bburl\'].\"/\".$vbulletin->options[\'imgdir\'].\"/\".$row[\'imgfile\'];\r\n $vbimghost[\'dispath\']=$vbulletin->options[\'bburl\'].\"/vbimghost.php?do=displayimg&imgid=\".$row[\'imgid\'];\r\n $vbimghost[\'width\']=$row[\'imgwidth\'];\r\n $vbimghost[\'height\']=$row[\'imgheight\'];\r\n $vbimghost[\'date\']=date(\'Y-m-d\', $row[\'imgdate\']);\r\n if (file_exists($vbulletin->options[\'imgdir\'].\"/\".$row[\'thumbname\'])){\r\n $vbimghost[\'thumbpath\']=$vbulletin->options[\'bburl\'].\"/\".$vbulletin->options[\'imgdir\'].\"/\".$row[\'thumbname\'];\r\n $vbimghost[\'thumbsize\']=0;\r\n }else{ \r\n $vbimghost[\'thumbpath\']=$vbimghost[\'path\'];\r\n if ($row[\'imgwidth\'] <= $vbulletin->options[\'imgthumw\'])\r\n $vbimghost[\'thumbsize\']=$row[\'imgwidth\'];\r\n else \r\n $vbimghost[\'thumbsize\']=$vbimghost[\'imgthumw\'];\r\n }\r\n eval(\'$mimghost .= \"\'.fetch_template(\'vbimghost_memberbit\') . \'\";\');\r\n $vbimghost[\'more\'] = \"<a href=\'vbimghost.php?do=viewimages&id=$userinfo[userid]\'>\" .construct_phrase($vbphrase[\'vbimghost_viewmore\'],$row2[\'mark\']).\"</a>\";\r\n } \r\n}else{\r\n $vbimghost[\'more\'] = \"\";\r\n eval(\'$mimghost =\"\'.fetch_template(\'vbimghost_memberbit_noimg\' ) . \'\";\');\r\n}\r\n\r\n$vbimghost[\'last5\'] = $mimghost;\r\nunset($row);\r\nunset($row2);', 'ao_vbimghost');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Tuesday, December 12th 2006 @ 11:28:14 PM
Script : http://www.XXXXXXXXXXX.com/vbulletin/admincp/plugin.php
Referrer : http://www.XXXXXXXXXXX.com/vbulletin...?do=productadd
IP Address : XXXXXXXXXX
Username : BadRobot
Classname : vb_database

----------------------------------------------------------------------

I am attempting to install version 1.4.1

Jon
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01072 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete