Thread: Miscellaneous Hacks - Rules and User Agreement Hack
View Single Post
  #258  
Old 01-26-2007, 08:48 PM
echamberlain's Avatar
echamberlain echamberlain is offline
 
Join Date: Aug 2006
Location: San Francisco
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I ran into an error installing the 3.6.x zipped fix, here was my workaround, incase others have this problem.

The symptom was that the Importing Product task bar would keep growing and not stop. The error log had the following entry:

PHP Fatal error: Cannot use object of type mysqli_result as array in /var/www/html/vBulletin/admincp/plugin.php(1941) : eval()'d code on line 35, referer: https://xxxxxx/admincp/plugin.php?do=productadd

To fix this error, I modified product-rulesagreement.xml and removed the if statement in the install code, by changing the code from

PHP Code:
$xx $db->query("select * from " .  TABLE_PREFIX "user");
    if (
$xx[agreedrule]=='')
     {
$db->query("ALTER TABLE " .  TABLE_PREFIX "user ADD agreedrule TEXT NOT NULL ");
      }
$db->query("DELETE FROM " TABLE_PREFIX "cron WHERE filename like '%cron/cron_ruleshack.php'"); 
to

PHP Code:
$xx $db->query("select * from " .  TABLE_PREFIX "user");
$db->query("ALTER TABLE " .  TABLE_PREFIX "user ADD agreedrule TEXT NOT NULL ");
$db->query("DELETE FROM " TABLE_PREFIX "cron WHERE filename like '%cron/cron_ruleshack.php'"); 
This is a manual workaround, so make sure the agreedrule column does not exist (select agreedrule from vb_users) before making this change.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01188 seconds
  • Memory Usage 1,780KB
  • 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
  • (2)bbcode_php
  • (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