/me clicks install, great update! works great!

- SpeedysWorld

Hmm... try running this:

I"m using the updated hack..and have no admcp options in user reg? What have I done wrong?

I'm using that query u gave me rob and i get

INSERT INTO `setting` ( `varname` , `groupttitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` )
VALUES (

'regpmfrom', 'register', '1', '1', '', 140, 0, 0
)

MySQL said:

#1054 - Unknown column 'groupttitle' in 'field list'

Did you run the queries that were specified in the file?

Vivi Ornitier: My bad.. an extra `t` slipped in:

You may also need updated queries for the others if that works:

You might want to let them know how to turn smilies on for the pms (changing the 0 to 1). ;)

Also, can this be set up to only send the pm on activation? I don't allow pms until they are activated. ;)

I think these errors might have t odo with left over vb2 tables from the hacks on that site. dunno though

Those all worked rob, yet when i run the 4th query from the install file it gives me

SQL-query :

INSERT INTO `setting`
VALUES (

'regpmtext', 'register', 'Hi $username and welcome to $bbtitle!\r\n\r\nWe appreciate you taking the time to register on our site and we hope you enjoy your stay.\r\n\r\nIf you have any questions, you can ask an administrator for assistance.\r\n\r\nWe hope to see you around.\r\n\r\nSincerely,\r\nThe $bbtitle staff', 'Hi $username and welcome to $bbtitle!\r\n\r\nWe appreciate you taking the time to register on our site and we hope you enjoy your stay.\r\n\r\nIf you have any questions, you can ask an administrator for assistance.\r\n\r\nWe hope to see you around.\r\n\r\nSincerely,\r\nThe $bbtitle staff', 'textarea', 150, 0, 1
)

MySQL said:

#1136 - Column count doesn't match value count at row 1

i ran all the queries, have no settings in the ACP under 'User Registration Options'.

and now, after saving the settings even though the new ones were not there we have this when trying to register:

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT username,userid FROM user WHERE userid=register
mysql error: Unknown column 'register' in 'where clause'

mysql error number: 1054

Date: Friday 02nd of April 2004 02:54:23 AM
Script: http://www.gamers-gateway.com/vb/register.php
Referer: http://www.gamers-gateway.com/vb/register.php

i have had to shut my board because of this, i trust somebody will be kind enough to help....