Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
Reload this Page Installed the homepage hack, and getting MYSQL 1064 error code
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 2 1 2
 
Thread Tools
Installed the homepage hack, and getting MYSQL 1064 error code Details »»
Installed the homepage hack, and getting MYSQL 1064 error code
Version: , by rzotz rzotz is offline
Developer Last Online: Feb 2012 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 05-01-2003 Last Update: Never Installs: 0
 
No support by the author.

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:

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 05-01-2003, 05:24 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
WHERE forumid IN( )

you should enter at least one id here
Reply With Quote
  #3  
Old 05-01-2003, 05:30 PM
rzotz rzotz is offline
 
Join Date: Apr 2003
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Today at 01:24 PM Xenon said this in Post #2
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?
Reply With Quote
  #4  
Old 05-01-2003, 05:43 PM
Smoothie Smoothie is offline
 
Join Date: Oct 2001
Location: New York
Posts: 1,834
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Today at 02:23 PM rzotz said this in Post #1
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?
Reply With Quote
  #5  
Old 05-01-2003, 05:43 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #6  
Old 05-01-2003, 05:46 PM
Smoothie Smoothie is offline
 
Join Date: Oct 2001
Location: New York
Posts: 1,834
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
if its vBhome lite simply set and save your vbHL Front Page options.
It will take care of your error.
Reply With Quote
  #7  
Old 05-01-2003, 05:47 PM
rzotz rzotz is offline
 
Join Date: Apr 2003
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Today at 01:43 PM Xenon said this in Post #5
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...ack&hackid=280

is the hack.
Reply With Quote
  #8  
Old 05-01-2003, 05:49 PM
Smoothie Smoothie is offline
 
Join Date: Oct 2001
Location: New York
Posts: 1,834
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Today at 02:47 PM rzotz said this in Post #7
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...ack&hackid=280

is the hack.
Read my post above yours, it is mentioned a hundred times in that thread how to fix.
Reply With Quote
  #9  
Old 05-01-2003, 06:05 PM
rzotz rzotz is offline
 
Join Date: Apr 2003
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #10  
Old 05-01-2003, 09:47 PM
drumsy's Avatar
drumsy drumsy is offline
 
Join Date: Nov 2001
Location: Charlotte, NC
Posts: 292
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Today at 03:05 PM rzotz said this in Post #9
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
Code:
forum/images
as the code to insert.
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 06:55 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05358 seconds
  • Memory Usage 2,292KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete