PDA

View Full Version : Installed the homepage hack, and getting MYSQL 1064 error code

rzotz
05-01-2003, 05:23 PM
Any help would be apperciated...Can't figure out why its not working.

www.sah2o.com

Forums are at www.sah2o.com/forum

And here is the error.....

Database error in vbHome 2.3.0:

Invalid SQL:
SELECT COUNT(*) AS total
FROM thread
WHERE forumid IN( ) AND dateline>1051810422

mysql error: You have an error in your SQL syntax near ') AND dateline>1051810422 ' at line 4

mysql error number: 1064

Date: Thursday 01st of May 2003 11:20:07 AM
Script: http://www.sah2o.com/forum/
Referer:
Xenon
05-01-2003, 05:24 PM
WHERE forumid IN( )

you should enter at least one id here
rzotz
05-01-2003, 05:30 PM
Today at 01:24 PM Xenon said this in Post #2 (https://vborg.vbsupport.ru/showthread.php?postid=390062#post390062)
WHERE forumid IN( )

you should enter at least one id here



What kind of ID are we talking about? Any #?

Also what file do I edit?
Smoothie
05-01-2003, 05:43 PM
Today at 02:23 PM rzotz said this in Post #1 (https://vborg.vbsupport.ru/showthread.php?postid=390061#post390061)
Any help would be apperciated...Can't figure out why its not working.

www.sah2o.com

Forums are at www.sah2o.com/forum

And here is the error.....

Database error in vbHome 2.3.0:

Invalid SQL:
SELECT COUNT(*) AS total
FROM thread
WHERE forumid IN( ) AND dateline>1051810422

mysql error: You have an error in your SQL syntax near ') AND dateline>1051810422 ' at line 4

mysql error number: 1064

Date: Thursday 01st of May 2003 11:20:07 AM
Script: http://www.sah2o.com/forum/
Referer:
which homepage hack, Tecks vBhome lite?
Xenon
05-01-2003, 05:43 PM
well the id of a forum which should be affected by this hack...

as you haven't posted a link to the hack i cannot help further
Smoothie
05-01-2003, 05:46 PM
if its vBhome lite simply set and save your vbHL Front Page options.
It will take care of your error.
rzotz
05-01-2003, 05:47 PM
Today at 01:43 PM Xenon said this in Post #5 (https://vborg.vbsupport.ru/showthread.php?postid=390074#post390074)
well the id of a forum which should be affected by this hack...

as you haven't posted a link to the hack i cannot help further

Where do I get the forum ID from? I understand that part...but have no clue where this forum ID is.

http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=280

is the hack.
Smoothie
05-01-2003, 05:49 PM
Today at 02:47 PM rzotz said this in Post #7 (https://vborg.vbsupport.ru/showthread.php?postid=390078#post390078)
Where do I get the forum ID from? I understand that part...but have no clue where this forum ID is.

http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=280

is the hack. Read my post above yours, it is mentioned a hundred times in that thread how to fix.
rzotz
05-01-2003, 06:05 PM
Okay, now I haev read it and got it working, but it doesn't look right. Take a look at http://www.sah2o.com the avatars are not working and I did follow the instructions ot the T. So please more advice. Thanks.
drumsy
05-01-2003, 09:47 PM
Today at 03:05 PM rzotz said this in Post #9 (https://vborg.vbsupport.ru/showthread.php?postid=390083#post390083)
Okay, now I haev read it and got it working, but it doesn't look right. Take a look at http://www.sah2o.com the avatars are not working and I did follow the instructions ot the T. So please more advice. Thanks.


Make sure your {imageshome} replacement has forum/imagesas the code to insert.
rzotz
05-01-2003, 10:00 PM
Today at 05:47 PM drumsy said this in Post #10 (https://vborg.vbsupport.ru/showthread.php?postid=390181#post390181)
Make sure your {imageshome} replacement has forum/imagesas the code to insert.

It does which doesn't make sense.