[SpeedysWorld]

/me clicks install, great update! works great!

- SpeedysWorld

[rob_daemon]

Originally Posted by Vivi Ornitier

i get this when runnin the first query.

SQL-query :

INSERT INTO `setting`
VALUES (

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

MySQL said:


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

Hmm... try running this:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[blubber12]

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

[Vivi Ornitier]

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'

[rob_daemon]

Originally Posted by blubber12

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

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

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

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[Boofo]

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.

[Hobbes]

Originally Posted by Vivi Ornitier

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'

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

[Vivi Ornitier]

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

[nemesis01]

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

[nemesis01]

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....

[msimplay]

Originally Posted by nemesis01

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....

there was a little part in the instructions that told you to go to registration options and press save once otherwise you will get sql errors

[nemesis01]

and if you had read my post properly you will see i did that, even though after running the queries that were supposed to insert those options didn't work.

[msimplay]

Originally Posted by nemesis01

and if you had read my post properly you will see i did that, even though after running the queries that were supposed to insert those options didn't work.

have you got any other hacks in register.php
because if u make a tiny mistake it can throw the whole forum off

[nemesis01]

nope, it is a virgin file.

[msimplay]

Originally Posted by nemesis01

nope, it is a virgin file.

try getting a default register php and rehacking it

EDIT just registered at your site and it seems u have private messages turned off for users awaiting email activation try turning it on