[nemesis01]

might work, however as i said the queries i ran to insert the admincp options are not there so i couldn't even configure it anyway.

[msimplay]

Originally Posted by nemesis01

might work, however as i said the queries i ran to insert the admincp options are not there so i couldn't even configure it anyway.

did you use phpmyadmin or vbulletin querie system ?

[nemesis01]

i used the vbulletin system, never had a problem with that before, even when it was a hack on vb2.

[msimplay]

Originally Posted by nemesis01

i used the vbulletin system, never had a problem with that before, even when it was a hack on vb2.

back up your database and rerun the queries
it should insert the options check my attachment so u know what it looks like

options>registration options

[nemesis01]

nope, all i keep getting is:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry 'regpmfrom' for key 1

[msimplay]

Originally Posted by nemesis01

nope, all i keep getting is:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry 'regpmfrom' for key 1

are you sure ur host hasnt disabled the querie ?
as i had a similar problem while flushing post tables

[nemesis01]

yes i am quite sure of that, i just ran the queries on my private .htacess protected test board which is located on the same server and it worked....

[Logikos]

Very nice, been waiting for this

/me clicks install

[rob_daemon]

Originally Posted by 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

Try running this:

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

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

First, go into phpMyAdmin and run these queries to remove any thing that you had previously added to the database:

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

It definitely sounds like the option queries weren't executed... make sure you run the quires via phpMyAdmin that are found in the instruction file (I believe that the vB query system only allows 1 query at a time).

[Mijae]

Originally Posted by rob_daemon

Try running this:

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

First, go into phpMyAdmin and run these queries to remove any thing that you had previously added to the database:

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

It definitely sounds like the option queries weren't executed... make sure you run the quires via phpMyAdmin that are found in the instruction file (I believe that the vB query system only allows 1 query at a time).

Won't work for me, no matter how many times I rerun the queries, nothing shows up in the admincp, and I get errors when someone registers.

[rob_daemon]

Originally Posted by Mijae

Won't work for me, no matter how many times I rerun the queries, nothing shows up in the admincp, and I get errors when someone registers.

What version of vB are you running?

[nemesis01]

I tried that just now, still no luck. The admincp options simply do not show up, I have even had my host run these queries and he can't explain it either.

[nemesis01]

I have just noticed actually, the test board I run is still RC4 (forgot to update ghehe) and my normal board is Gold so maybe that is the problem.

[Mijae]

Originally Posted by nemesis01

I have just noticed actually, the test board I run is still RC4 (forgot to update ghehe) and my normal board is Gold so maybe that is the problem.

I have vB3.0.0 GOLD.

Still wont work

[nemesis01]

Originally Posted by Mijae

I have vB3.0.0 GOLD.

Still wont work

Yes, that's what I mean, I can't get it to work on Gold either yet it will on RC4.