Thread: Usenet gateway
View Single Post
  #71  
Old 02-13-2001, 08:02 PM
Guest
  
Posts: n/a
Default
The problem seems to be that 'null' is being inserted into the threadid column. As far as I can see, there are two possible reasons for this error:

Number 1 is line 292 that reads
Code:
$threadid = $dbh->{'mysql_insertid'};
is failing for some reason. mysql_insertid is a built in mysql function and returns the id of the last inserted record. I have no idea why this would not work on your setup. What version of Perl and MySQL are you using?

Number 2 is if the query on line 306 was pulling back null for the threadid column from the thread table. Now this is virtually impossible as threadid is an auto_increment column with a unique index on it.

I don't want to ask the obvious, but I will you are installing this on version 1.15 or 1.114 right?

I'll need to do some more investigation. I'll get back to you.

As for the SQL instructions. I'm an Oracle DBA so I'm used to tablenames only being case sensitive if you put double quotes around them. I will correct them asap.

regards
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02987 seconds
  • Memory Usage 1,755KB
  • 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)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_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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete