vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   URGENT! Major template problems - not loading modified ones, some disappearing! (https://vborg.vbsupport.ru/showthread.php?t=57808)

X-Fan 10-12-2003 01:09 AM

URGENT! Major template problems - not loading modified ones, some disappearing!
 
I need some urgent help here, please. I just went to check my Web site for the first time this morning...

http://www.comixfan.com/xfan/index.php?s=

...and I'm getting this error:

Quote:

Database error in vbHome :

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

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

mysql error number: 1064

Date: Saturday 11th of October 2003 10:05:15 PM
Script: /xfan/index.php?s=
Referer:
The site was working fine around 8 hours ago, and no code has been edited/added/deleted since then but now all of a sudden it's stopped because of this error.

What could the problem be?

X-Fan 10-12-2003 01:14 AM

Addendum: I've just discovered my site has been hacked, as the board was turned off in the admin and there was a rather rude message posted as the close reason.

The database appears to be intact, it's just that mysql error with every instance of dateline that's causing problems from what I can see.

Any help would be appreciated, thanks!

X-Fan 10-12-2003 01:25 AM

Update 2: My templates aren't listing in my site admin. They're still in the database, but when I go to modify them nothing shows up in the list.

How do I fix that?

X-Fan 10-12-2003 12:30 PM

Okay, I managed to get the default templateset back, however now I get a bare bones forum front page with a blank message box in the middle of the screen:

http://www.comixfan.com/xfan/forums/index.php?s=

I've tried editing the forumhome template, but for some reason the system is using only the default template and none of my modified ones.

In fact, the system isn't reading any of the stored variables, such as $hometitle, $bburl, etc. Not even $versionnumber is being read so currently my vB is null version!

I've also tried upgrading to 2.3.2, but even that causes a problem as no version number shows up for vBulletin. I re-uploaded vbulletin.style to the FTP and went to import it, but got this error:

Quote:

The version of the style file does not match your version of vBulletin. Please obtain an updated version of vBulletin and/or the style file.

Your template version:

Style file template version: 2.3.2
I've checked my database, and all posts, threads, forums, users etc are still there. I've checked all the settings in the admin and the board is open, forums are visible, usergroups are established and permissions as they were before the hack attack, but just nothing is showing up on the index page.

Please, can someone help, as my site is my livelihood and every minute it's down is lost revenue for me! :(

Lesane 10-12-2003 01:10 PM

I have no idea at this moment, but check your database if the table 'setting' contains all the settings(it will probably) and run the repair.php and upload the original global.php/functions.php/index.php again.

X-Fan 10-12-2003 01:14 PM

Did all that, Lesane, and still no go. vBHome isn't working properly either since the hacker attack:

http://www.comixfan.com/xfan/index.php?s=

For some reason it's only reading the default templates. Any template modifications I make aren't being displayed.

X-Fan 10-12-2003 01:21 PM

I think the root problem is that the PHP code isn't getting the variable info from the database. I think that's why it's using the master templateset to display the pages because it's not getting passed the id of the default templateset. It's also why there's no version number being displayed, or any other variables like $hometitle and the like.

What could be causing that problem, though, when the DB settings in config.php are correct?

X-Fan 10-12-2003 10:31 PM

Someone, anyone, please, I desperately need help here! :(

Erwin 10-12-2003 11:58 PM

Reupload all the PHP files and see if that helps.

X-Fan 10-13-2003 12:11 AM

I have done, Erwin, twice, to no avail. :(

Thanks for helping, btw. I've been freaking out here as my site is my livelihood!


All times are GMT. The time now is 01:19 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01610 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete