![]() |
|
|
Thread Tools |
|
#1
|
||||||||||||||||
|
||||||||||||||||
|
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
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
adding content to last entry, aswell as no auto value.
content in both
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 - I'll be leaving VB, to much of a hassle using it follow the white rabbit, feed! your head
No members have liked this post.
Last edited by Vaupell : 19 Feb 2009 at 13:45. Reason: Auto-Merged DoublePost |
||||||||||||||||
|
#2
|
||||
|
||||
|
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. No members have liked this post.
|
|
#3
|
||||
|
||||
|
Originally Posted by Dismounted
dont get it ?
__________________
My website Evisystems 2013 - I'll be leaving VB, to much of a hassle using it follow the white rabbit, feed! your head
No members have liked this post.
|
|
#4
|
||||
|
||||
|
__________________
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. No members have liked this post.
|
|
#5
|
||||
|
||||
|
Originally Posted by Dismounted
yes thank you that part i got.
but the reference to the manual you linked i dont get.
__________________
My website Evisystems 2013 - I'll be leaving VB, to much of a hassle using it follow the white rabbit, feed! your head
No members have liked this post.
|
||||
|
#6
|
||||
|
||||
|
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. No members have liked this post.
|
|
#7
|
||||
|
||||
|
ahhh.. allright thank you!
![]()
__________________
My website Evisystems 2013 - I'll be leaving VB, to much of a hassle using it follow the white rabbit, feed! your head
No members have liked this post.
|
![]() |
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
| Thread Tools | |
|
|
| New To Site? | Need Help? |
All times are GMT. The time now is 08:26.

(debug enabled on test ofcourse)



