View Single Post
  #45  
Old 01-09-2005, 03:28 PM
Intex Intex is offline
 
Join Date: Apr 2002
Posts: 576
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Abe - It looks like it's because the queries didn't run properly to me. I tried running one of the ones from the install file directly in phpadmin:

Code:
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)");

Produced the following error:

Code:
Error
 
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
 
ERROR: Unknown Punctuation String @ 9
STR: ->
SQL: $DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)")
SQL-query : 
 
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)") 
 
MySQL said: 
 
 
#1064 - 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 '$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES
All the queries where the syntax is using 'INSERT INTO' produce the same problem and these are all related to the settings. The other queries which ALTER tables, such as the 'user' and 'post' run successfully and they're working because it's tracking the amount of thank you's someone has.

Can you see what's wrong with the syntax? I'm running 3.0.1 and mySQL 3.23.49.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01205 seconds
  • Memory Usage 1,766KB
  • 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_code
  • (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