(Link to AcmlmWiki) Offline: thank ||bass
Register | Login
Views: 13,040,846
 Main | Memberlist | Active users | Calendar | Chat | Online users
Ranks | FAQ | ACS | Stats | Color Chart | Search | Photo album 		05-03-24 10:53 AM
0 users currently in Programming.
Acmlm's Board - I3 Archive - Programming - New server problems (per friend's request) New poll | |
Add to favorites | Next newer thread | Next older thread
User Post
Tatrion
<_<;


 





Since: 11-17-05

Last post: 6284 days
Last view: 6283 days
Posted on 08-12-06 10:04 PM Link | Quote
Originally posted by stag 019
I moved an AcmlmBoard from funpic to my netfirms server, and posts no longer insert into neither `posts` nor `posts_text`. However, it can't be the INSERT queries, as guests insert properly.
The Funpic board was running "MySQL 4.1.20-nightly-20060502-log running on localhost as stag019board@192.168.101.1", and the netfirms server runs "MySQL 4.1.12-log running on MySQL Server Farm 2
as u70282523@cgihost". Any ideas?

P.S, Switching between PHP 4 and 5 makes no difference.


P.P.S, If I respond to this, it'll be from stag, not me, as this isn't really my problem, and I understand very little about it
Cellar Dweller +

Red Koopa









Since: 11-18-05
From: Arkansas

Last post: 6293 days
Last view: 6283 days
Posted on 08-13-06 12:12 AM Link | Quote
It might be useful to add print statements right before of after the INSERT queries that show the exact same strings that are passed to the mysql_query functions. Also, try adding "print mysql_error();" somewhere after the INSERT queries, but before any other MySQL functions. Then, try to post a reply.

If that doesn't tell you what the problem is, try posting the output here.

(edited by Cellar Dweller + on 08-12-06 11:35 PM)
Razman

Red Paragoomba








Since: 11-17-05
From: Where I can kick your ass

Last post: 6472 days
Last view: 6472 days
Posted on 08-13-06 12:07 PM Link | Quote
Originally posted by stag019
Well, apparently, when dumping from the funpic's server, field `id` didn't have auto_increment attatched to it at the end, nor did any other table. I think funpic notices that when AUTO_INCREMENT=num is at the end, then the PRIMARY KEY is automatically set to auto_increment, which is why my backups have never had a problem before on funpic. So now I have to go through each table and add auto_increment to any ones that need it.
Thanks for the help, and this can be closed now.
Add to favorites | Next newer thread | Next older thread
Acmlm's Board - I3 Archive - Programming - New server problems (per friend's request) |


ABII

Acmlmboard 1.92.999, 9/17/2006
©2000-2006 Acmlm, Emuz, Blades, Xkeeper

Page rendered in 0.021 seconds; used 358.85 kB (max 426.25 kB)