PDA

View Full Version : Arcade Problem



Mr. J Jones
04-06-2006, 12:27 AM
username: test
password: test


Site: http://www.blue-inc.org

Problem: If you click on my arcade you'll get an error, also if you click a thread that is part of my forum then you'd also get a problem, these are the errors I am getting:

I did go to the support center provided by this forum. But Il post my problem.
I get this error below trying to view the arcade (blue-inc.org/arcade.php)



Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM arcade_challenges AS arcade_challenges
LEFT JOIN user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 10;
MySQL Error : Table 'blueinc_vb.arcade_challenges' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 11:49:26 AM
Script : http://www.blue-inc.org/arcade.php
http://www.blue-inc.org/index.php
IP Address : xxxxx :tear: not telling you this.
Username : echo_unlimited
Classname : vb_database


Also I get these errors while veiwing a thread:



Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT title,highscorerid,highscore,miniimage,gameid FROM arcade_games WHERE highscorerid IS NOT NULL AND (gamepermissions & 2);
MySQL Error : Table 'blueinc_vb.arcade_games' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:39:27 PM
Script : http://www.blue-inc.org/showthread.php?p=519#post519
Referrer : http://www.blue-inc.org/index.php
IP Address : ---------
Username : echo_unlimited
Classname : vb_database


And while when I go into ACP>>Arcade>> Catagorys:



Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT * FROM arcade_categories AS arcade_categories ORDER BY displayorder ASC;
MySQL Error : Table 'blueinc_vb.arcade_categories' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:40:41 PM
Script : http://www.blue-inc.org/admincp/arcadeadmin.php?do=categories
Referrer : http://www.blue-inc.org/admincp/index.php?do=nav
IP Address :-------------
Username : echo_unlimited
Classname : vb_database


ACP>>Arcade>>Games:




Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT COUNT(*) AS total
FROM arcade_games AS arcade_games;
MySQL Error : Table 'blueinc_vb.arcade_games' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:41:23 PM
Script : http://www.blue-inc.org/admincp/arcadeadmin.php?do=games
Referrer : http://www.blue-inc.org/admincp/index.php
IP Address : -------------
Username : echo_unlimited
Classname : vb_database


Thats all the errors I get, plus its affecting my forum


How would I fix these? I done some thing to my site and i don't know how to fix these errors.

It was working before, I just don't understand what went wrong :(


Thanks.

Joeychgo
04-06-2006, 12:46 AM
I have never installed the arcade, but it looks like you damaged your database somehow.

Joeychgo
04-06-2006, 01:03 AM
If you did a backup, I would restore the backup. If you didnt, contact your host and see if they did a backup.

Mr. J Jones
04-06-2006, 02:27 AM
If you did a backup, I would restore the backup. If you didnt, contact your host and see if they did a backup.


I think I done a back up, but I don't know how to implement it. :( :confused: Anyone willing to tell me how? I have the back up on my FTP in .tar file. It goes back to 4th.2nd.2006

Joeychgo
04-06-2006, 02:30 AM
BTW, if you didnt do a backup - in the future -

ALWAYS BACKUP BEFORE INSTALLING A HACK!!!!


:)

Mr. J Jones
04-06-2006, 02:35 AM
BTW, if you didnt do a backup - in the future -

ALWAYS BACKUP BEFORE INSTALLING A HACK!!!!


:)


I have a backup, I just don't know how to implement it.

Joeychgo
04-06-2006, 02:46 AM
Best thing then is to ask your hsot to restore it for you.

Mr. J Jones
04-06-2006, 02:47 AM
Best thing then is to ask your hsot to restore it for you.

Way a head of you :p

I asked them, hopefully they'll reply soon

Joeychgo
04-06-2006, 02:51 AM
Good luck - keep us advised.

Mr. J Jones
04-06-2006, 02:56 PM
Yeah, they done the database restore and it went quite well :)

Thanks.

Peggy
04-06-2006, 03:53 PM
so do you have an arcade now or not?

Mr. J Jones
04-07-2006, 01:56 AM
Yep I got an arcade :) But does any one know where I can learn to do a restore?

Peggy
04-07-2006, 03:49 AM
Yep I got an arcade :) But does any one know where I can learn to do a restore?

a restore of what?

Mr. J Jones
04-07-2006, 04:44 AM
Sorry I meant a back-up; how could I implement a back up.

Peggy
04-07-2006, 04:55 AM
OH... there's a backup feature in your vBulletin. Go to your adminCP, scroll down to Maintenance, click on database backup. You can backup one table or the entire thing. ;)

Mr. J Jones
04-07-2006, 03:50 PM
OH... there's a backup feature in your vBulletin. Go to your adminCP, scroll down to Maintenance, click on database backup. You can backup one table or the entire thing. ;)

I tried that and I got this error:


Unable to write backup to file ./forumbackup-04-07-2006-aac80.sql. This file or the directory this file is in must be world writable!


I swear vBulletin hates me. :(

Wait a minute do I download the back up, or some thing? or is it saved on the hosting account I have? :confused:


Thanks.

Joeychgo
04-07-2006, 03:51 PM
Best thing then is to ask your hsot to restore it for you.



Simple.....

Mr. J Jones
04-07-2006, 03:54 PM
Simple.....

Yeah I know that. But how do I actually save a back up of my site if want to restore it if I have made an error.


example:

'I have just intalled a shoutbox, but I have made an error during the instalation, but before hand I had made a back of the forum'

What I am asking is how can I make a back up of my forum?

Joeychgo
04-07-2006, 04:40 PM
Depends on the kind of control panel you have. I know how I do it. I dont use the vBuletin database backup system at all.

Mr. J Jones
04-07-2006, 05:01 PM
I have cPanel at the moment.

Peggy
04-07-2006, 06:39 PM
hmmm.. I always do a DB backup in vB

Mr. J Jones
04-08-2006, 02:22 AM
hmmm.. I always do a DB backup in vB


Just wondering do you download the back up or will it save automatically on your server?

Peggy
04-08-2006, 07:47 AM
it will save on your server, but I always download it. what if the server goes down?? you've lost your backup ;)