Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Feb 2009, 13:24
Vaupell's Avatar
Vaupell Vaupell is offline
 
Join Date: Apr 2008
Real name: Martin
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

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


adding content to last entry, aswell as no auto value.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


content in both

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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

--------------- Added 19 Feb 2009 at 13:45 ---------------

oh my god, im such an idiot..

" . TABLE_PREFIX ."
__________________
My website Evisystems
2013 - Looking for an easier board than Vb
follow the white rabbit, feed! your head

Last edited by Vaupell : 19 Feb 2009 at 13:45. Reason: Auto-Merged DoublePost
Reply With Quote
  #2  
Old 20 Feb 2009, 04:31
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
It's good practise to always specify the fields you are inserting to! Furthermore, this is required in the vBulltin Code Standards document.
__________________
View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #3  
Old 20 Feb 2009, 06:07
Vaupell's Avatar
Vaupell Vaupell is offline
 
Join Date: Apr 2008
Real name: Martin
Originally Posted by Dismounted View Post
It's good practise to always specify the fields you are inserting to! Furthermore, this is required in the vBulltin Code Standards document.
dont get it ?
__________________
My website Evisystems
2013 - Looking for an easier board than Vb
follow the white rabbit, feed! your head
Reply With Quote
  #4  
Old 20 Feb 2009, 06:18
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 20 Feb 2009, 06:23
Vaupell's Avatar
Vaupell Vaupell is offline
 
Join Date: Apr 2008
Real name: Martin
Originally Posted by Dismounted View Post
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
yes thank you that part i got.

but the reference to the manual you linked i dont get.

$code = red_code($var); Don't code like this
$code = normal_code($var); Code like this
__________________
My website Evisystems
2013 - Looking for an easier board than Vb
follow the white rabbit, feed! your head
Reply With Quote
  #6  
Old 20 Feb 2009, 06:41
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
I linked to the section - look at the sub-categories on the left. (The page you landed on describes the key, if you read it.)
__________________
View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #7  
Old 20 Feb 2009, 08:20
Vaupell's Avatar
Vaupell Vaupell is offline
 
Join Date: Apr 2008
Real name: Martin
ahhh.. allright thank you!
__________________
My website Evisystems
2013 - Looking for an easier board than Vb
follow the white rabbit, feed! your head
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 10:46.

Layout Options | Width: Wide Color: