Re-add, edit the templates...

Got this error when looking at bet statistics

"Database error in vBulletin 3.0.1:

Invalid SQL: SELECT u.username, (p.+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid

mysql error number: 1064

Date: Thursday 01st of July 2004 09:12:28 PM
Script: http://www.********.com/forum/vbookie.php?do=stats"

And when I check yes,post a vbookie event with this post .. I get a blank page .. ??

Damn AliceBOT got me again. I gotta remove that hack someday.

Thanks for the help.

Anyway to set it so only certain users (instead of usergroup) can post an event? That is, other than putting that user into a new group and assigning permissions to the group.

Also, is there any way to allow event posting into certain forums only?

I would love it if my moderators could post events but only in the forums that they moderate.

ideas?

Doesn't appear to work on 3.0.1 .. perhaps that should be included in the installation file :disappointed:

Dude. I run this at my site at http://www.dungeonkeepersdomain.com and it is running v3.01. It is working just fine.

Dude .. I and 2 admins from my site have tried the install on 3.0.1 three times and had the same database error's on every installation .. installed arcade / petz with no problems on my main forum .. will not be trying this until the database errors are corrected .. any useful comments anyone .. !?

Useful comments might follow useful problem reports. What, for example, do the database errors say?

As listed above .. !?

Got this error when looking at bet statistics

"Database error in vBulletin 3.0.1:

Invalid SQL: SELECT u.username, (p.+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid

mysql error number: 1064

Date: Thursday 01st of July 2004 09:12:28 PM
Script: http://www.********.com/forum/vbookie.php?do=stats"

================================================== =======

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT FROM WHERE userid='1'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM WHERE userid='1'' at line 1

mysql error number: 1064

And when I check yes,post a vbookie event with this post .. I get a blank page .. ??

That's nothing to do with installation, sorry. Your phrasing in the last post mis-led me.

The problem here is the "(p.+0)" and "FROM AS p". Those should contain the uCash column and table, e.g. "(p.money+0)" and "FROM user AS p" -- $vboptions['uttpoints_pointsfield'] and $vboptions['uttpoints_pointtable']. Check what these are set to in the Admin control panel.

I can't really suggest what might be wrong as I haven't got 3.0.1, but I can't see that there would be any major changes between 3.0.0 and 3.0.1. If you want to give me FTP and Admin access to your forum, I can take a look for you, but it won't be until Sunday evening at the earliest because I'm away at a wedding this weekend.