Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 02-19-2009, 12:24 PM
Vaupell's Avatar
Vaupell Vaupell is offline
 
Join Date: Apr 2008
Location: Esbjerg, Denmark
Posts: 1,036
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default SOLVED - Populating data into SQL works on one board, but not another - SOLVED

adding some "standard / exsample" data to my product.

Howewer on my "clean" test board data adds fine,
but when i test on my live board no data is added,
And "other" modifications should not have any influence on this at
all, since its using its own table, and its dureing installation..


Both my test and my live is 3.8.1 only difference is the SQL version.
On my local test board im running the latest
sql 5.1.3, and php 5.2.8
and my live server which i dont control, but is hostet at a webhost
i have sql 5.0.51a and php 5.1.6

Does the following query not work on any of the above version ?
how do i check, and if needed how do i rewrite ?
Exsample of what im trying to add
[sql]
$db->query_write("INSERT INTO `elinkscat` VALUES ('1', 'Default', '')");
[/sql]

on my local im using navicat to acces sql server tables and write the query's
i need, so i just have to wrab them with $db->query_write(" ...... ")


EDIT : Also tryed following which works on test board, but not a live board. (debug enabled on test ofcourse)

Removing the auto increase value
[sql]
$db->query_write("INSERT INTO `elinkscat` VALUES ('', 'Default', '')");
[/sql]

adding content to last entry, aswell as no auto value.
[sql]
$db->query_write("INSERT INTO `elinkscat` VALUES ('', 'Default', '1')");
[/sql]

content in both
[sql]
$db->query_write("INSERT INTO `elinkscat` VALUES ('1', 'Default', '1')");
[/sql]

All of these work on test board, but not on live.. huh ?

--------------- Added [DATE]1235054716[/DATE] at [TIME]1235054716[/TIME] ---------------

oh my god, im such an idiot..

" . TABLE_PREFIX ." :up:
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:31 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07641 seconds
  • Memory Usage 2,185KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)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)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete