webpost, db error

10-13-2003, 08:29 PM

I installed webpost for ts on my site. I can login to admin area fine and see
Active Servers: 1
Users Online: 4

but i can not access anything else. When i click anything, i get a blank page with this error on it.

[DATABASE ERROR:]1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group where (server_timestamp + 900) < '1066105559'' at line 1

I added a ss of the admin area

I have tried creating two different db's for this, and i can see the db's in phpMyadmin just fine.

Any idea why i get that error?

thanks
shiggy

Ghryphen · 10-14-2003, 09:21 AM

I visited your webpost and it appears to be working ok, is this something that only happens in the admin panel?

Type opening admin/tpl_admin_menu.php and find:

PHP Code:


			
<a href="../groups.php">Groups</a>: <? getgroupcount() ?><br>

change to:

PHP Code:


			
<a href="../groups.php">Groups</a>: <? // getgroupcount() ?><br>

You will not see the group count in your admin stats, but this will help narrow down the problem.

Stang · 10-14-2003, 10:26 AM

10-14-2003, 07:00 PM

got it fixed, just had to upload and re-install webpost again with a fresh download. thanks for the support

-shiggy

02-16-2004, 08:32 AM

had the same error and tried the fix mentioned above and
I can see the settings page, but thats it,
every other page gives the same error...

win2003 IIS6
Thanks,
GHBoom

10-13-2003, 08:29 PM	#1
shiggy Guest Posts: n/a	webpost, db error I installed webpost for ts on my site. I can login to admin area fine and see Active Servers: 1 Users Online: 4 but i can not access anything else. When i click anything, i get a blank page with this error on it. [DATABASE ERROR:]1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group where (server_timestamp + 900) < '1066105559'' at line 1 I added a ss of the admin area I have tried creating two different db's for this, and i can see the db's in phpMyadmin just fine. Any idea why i get that error? thanks shiggy

10-14-2003, 09:21 AM	#2
Ghryphen THZ Founder Join Date: Mar 2001 Location: WA, USA Age: 50 Posts: 3,927	I visited your webpost and it appears to be working ok, is this something that only happens in the admin panel? Type opening admin/tpl_admin_menu.php and find: PHP Code: `<a href="../groups.php">Groups</a>: <? getgroupcount() ?><br>` change to: PHP Code: `<a href="../groups.php">Groups</a>: <? // getgroupcount() ?><br>` You will not see the group count in your admin stats, but this will help narrow down the problem. __________________ The Hounds of Zeus \| Allied Tribal Forces

10-14-2003, 10:26 AM	#3
Stang Team Captain Join Date: Mar 2001 Location: Everett, WA, USA Age: 50 Posts: 3,859 Xbox Leaderboard: 1^st	__________________

02-16-2004, 08:32 AM	#5
Ghboom Guest Posts: n/a	had the same error and tried the fix mentioned above and I can see the settings page, but thats it, every other page gives the same error... win2003 IIS6 Thanks, GHBoom Last edited by Ghboom; 02-16-2004 at 08:39 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Webpost Admin loop	Chief	Suggestions / Feedback / Testing	16	03-02-2004 02:35 PM
Webpost help (like all newbs)	Xavier	Suggestions / Feedback / Testing	4	02-17-2004 01:16 PM
Join/Login Error (Webpost v4.0.2)	Solarance	Suggestions / Feedback / Testing	9	08-19-2003 06:03 PM
Webpost error	[SAC]Peperoni	Suggestions / Feedback / Testing	2	06-12-2003 12:59 PM
webpost in phpnuke	Dragon	Suggestions / Feedback / Testing	4	05-11-2003 09:49 PM

10-14-2003, 07:00 PM	#4
shiggy Guest Posts: n/a	got it fixed, just had to upload and re-install webpost again with a fresh download. thanks for the support -shiggy