Bug Database error received after upgrading...finally trying to fix.

Status
Not open for further replies.

ae1360

Customer
Short and simple: Get this error when you go to the arcade. I've reinstalled the XML and same error.
Code:
Database error in vBulletin 4.2.4:

Invalid SQL:
SELECT * FROM dbtech_vbarcade_session AS s LEFT JOIN dbtech_vbarcade_game AS g ON (s.gameid = g.gameid) WHERE g.scoring = 0 AND s.timefinish != 0 AND s.timefinish < 1495899564 AND s.score = 0 AND s.userid = 378 ORDER BY s.timestart ASC LIMIT 1;

MySQL Error   : Unknown column 's.timefinish' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, May 27th 2017 @ 03:41:24 PM
Error Date    : Saturday, May 27th 2017 @ 03:41:24 PM
Script        : http://URL/forum/arcade.php
 
Try running
Code:
ALTER TABLE dbtech_vbarcade_session ADD timefinish INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER timestart
 
Hello ae1360,

This ticket has now been closed with the status Cannot Reproduce.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!
 
Status
Not open for further replies.

Similar threads

  • Locked
  • Support ticket
Replies
4
Views
915
  • Locked
  • Support ticket
Replies
6
Views
2K
  • Locked
  • Support ticket
Question Database errors
Replies
2
Views
939
  • Locked
  • Support ticket
Replies
2
Views
845

Legacy vBArcade

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
898
Customer rating
0.00 star(s) 0 ratings
Back
Top