View Single Post
  #25  
Old 07-31-2002, 01:00 AM
TeddyBare69 TeddyBare69 is offline
 
Join Date: Jun 2002
Location: CA, US
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

stangpower, hellsatan, christy, anybody else with databases that don't like the ';'

I am not completely positive this will fix your first screen shot of errors though. I am looking into how those errors could be created. You are more than willing to try with this fix.

If I could find out what version database you are running? I have seen this error on visibleimpacts website as well and haven't figured out why it works on my test server but not on the production server.

Here is the fix. I am uploading a new file and giving fixit instructions.

This is an easy fix.

1. in your viPortfolio directory you have install.php
2. open that file and find line 1338
You should see this with or without line numbers depending on your editor:
1335 if ($onvservers==1 and substr($val, 0, 5)=="ALTER") {
1336 $DB_site->reporterror=0;
1337 }
1338 echo " .";
1339 $DB_site->query($val);
1340 if ( $DB_site->errno != 0 ) {
1341 echo "<P>Error #[".$DB_site->errno."]<BR>Message: [".$DB_site->errdesc."]<BR>SQL: [".$val."]<p>";
1342 return;
1343 }

3. Between lines 1338 and 1339 insert the following line.

$val[strpos( $val, ";" )] = " ";

4. Now your code will look like:
1335 if ($onvservers==1 and substr($val, 0, 5)=="ALTER") {
1336 $DB_site->reporterror=0;
1337 }
1338 echo " .";
1339 $val[strpos( $val, ";" )] = " ";
1340 $DB_site->query($val);
1341 if ( $DB_site->errno != 0 ) {
1342 echo "<P>Error #[".$DB_site->errno."]<BR>Message: [".$DB_site->errdesc."]<BR>SQL: [".$val."]<p>";
1343 return;
1344 }

If you don't feel comfortable making that change, I have attached the modifed install.php file here.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01185 seconds
  • Memory Usage 1,764KB
  • 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