webpost mysql error

Peperoni · #1 12-06-2003, 14:12

Hello guys,

i have installed the newest Teamspeak server
and the new webpost script.

first time is running the script without any problems but now i become an error.

"[DATABASE ERROR:]1064: You have an error in your SQL syntax near ') < '1055418464'' at line 1"

Look ---> http://sac-rtcw.de/sys/ts/listing.php

TS Server Version: 201940
PHPVersion: 4.2.2
mysqlversion: 3.23.52-log

can anybodyhelp me ?

B.Webeler · #2 12-06-2003, 15:15

same here,
happend when I switched "Refresh" on.
After setting refresh off it worked ...

Gryphon · #3 12-06-2003, 22:14

Peperoni, it looks like the Admin table was not created in your database. Did you run the install.php script?

B.Webeler, are you still having this problem?

Peperoni · #4 12-06-2003, 22:32

okay step for step:

i creat a database "webpost2"
i run the install.php
install DONE !

I login in the admin interface !
DONE !

but when i click on the sswebpost2 button to go to my listing page i become this ERROR

[DATABASE ERROR:]1064: You have an error in your SQL syntax near ') < '1055449890'' at line 1

hey Gryphon contact me via IRC and i give you access for selftesting !?

#silent-assassins

B.Webeler · #5 13-06-2003, 20:52

Since I switched refresh off it worked.

Looked like a bug in the script. I checked the DB after install, all data in the admin table was correct.
The I checked the webpage, everything ok. After klicking on details (was just one server in the list) I got the error above.

When I reloaded PHPMyAdmin all data in the admin table was lost.
So I had to setup the admin page again.
After a few tests I backuped the admin table and tested again. Every time refresh was on the admin table was dropped.

With Auto Refresh = off it runs stable since 2 days.

Slyvr · #6 22-06-2003, 06:03

I had the same thing happen. Upgraded from 3.1.1 to 4.0.2. Had auto refresh on and within a day I had lost the admin table. Turned off auto refresh after seeing your post, and haven't had a problem for 4 days now.

I don't know php well (yet), but am learning. I'll see if I can come up with something constructive to add after looking through it some.

Overall it's a fantastic script.

--
Another fine missive brought to you exclusively by
Slyvr

#7 08-07-2003, 21:16

I have the same problem as described above. It seems turning auto refresh off helped you. My problem is: What is and where can i find auto refresh?

thx for help

-={B4MB4M}=- · #8 28-07-2003, 01:19

Quote:

Originally posted by Peperoni
Hello guys,

i have installed the newest Teamspeak server
and the new webpost script.

first time is running the script without any problems but now i become an error.

"[DATABASE ERROR:]1064: You have an error in your SQL syntax near ') < '1055418464'' at line 1"

Look ---> http://sac-rtcw.de/sys/ts/listing.php

TS Server Version: 201940
PHPVersion: 4.2.2
mysqlversion: 3.23.52-log

can anybodyhelp me ?

I have this exact same problem, and it's true, since I leave the auto refresh checkbox alone....It runs ok....except for another issue wich involves the admin page.. But I've mentioned that one in another thread.....
Back to this issue : Is there a solution for this issue yet ?

btw : everytime you do a refresh of the page with the error message, the number changes

Regards
B4M

HIQ · #9 18-08-2003, 10:02

I have the same problem since 3 days.

So i put the script on a another server. and install all stuff.

After 5 minutes working, the same error Message.

Why from yesterday to day and why many user has this ?

In the time that work, i have every time seen an sql update error message, so i think its, because the auto update.

So i try an new installation and klick the update on off.

When it work, than i´m write it here again.

Sorry for my Bad Englisch !

HIQ · #10 18-08-2003, 10:37

ok, in the moment it works.

It works longer than 5 minutes.

Only what i have make other is

Go to Admin Panel -> Settings -> and than klick

"Check For Updates :
If you want the admin panel to automatically check for updates check yes."

to "NO"

So i dont get on the main window (admin/index.php) no error messages. When i make the update to yes i get error messages !

I think that the autoupdate try to fix the bugs with updates and kill the database, or anythink else. I dont know, but it works.

Sorry for my bad English.

Gretttzzzzzz

HiQ from HilfeForum.de

HIQ · #11 19-08-2003, 11:36

After 1 Day it Run without Problems

http://www.hiq.3dg.net/ts/listing.php