| rob_daemon |
04-02-2004 03:52 PM |
Quote:
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:
Code:
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) 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);
Quote:
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:
Code:
DELETE FROM setting WHERE varname = 'regpmfrom';
DELETE FROM setting WHERE varname = 'regpmtext';
DELETE FROM setting WHERE varname = 'regpmtitle';
DELETE FROM phrase WHERE varname = 'setting_regpmtext_title';
DELETE FROM phrase WHERE varname = 'setting_regpmtext_desc';
DELETE FROM phrase WHERE varname = 'setting_regpmtitle_title';
DELETE FROM phrase WHERE varname = 'setting_regpmtitle_desc';
DELETE FROM phrase WHERE varname = 'setting_regpmfrom_desc';
DELETE FROM phrase WHERE varname = 'setting_regpmfrom_title';
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). |
More Information