SQL Error

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

SQL Error

Post by casanova »

When a new member tries to register, i get the following

General Error
SQL ERROR [ mysql4 ]

Unknown column 'user_new_privmsg' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

------------------

Any Ideas?
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: SQL Error

Post by karlsemple »

Please provide us with the information necessary to assist you by filling out the Support Request Template.
Image
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

Re: SQL Error

Post by casanova »

Your board's URL:
Version of phpBB3: 3.0.1
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)?

Dumped the old data from a 3.0.0 Database to 3.0.1 database due to the 3.0.0 not being able to open PM's so could not find a fix and decided for a fresh install and using the data from old board to be moved across.

Did you use an automated wizard provided by your host to install phpBB? No
MODs you have installed: None
When the problem started: When i installed the board
Your level of expertise (be honest): Low

Additionally, you may wish to provide the following (where applicable)
Template(s) used: twilightBB Style by Daniel St. Jules
Language(s) used: English
Version of PHP used: Most uptodate
Database and version used: SQL
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: SQL Error

Post by karlsemple »

Are you sure all the data moved across? How did you move the data across, can we get a step by step of what you did? That column was present a long while back, it is not something recently added, not only that why have you gone to 3.0.1 when 3.0.2 is the newest?
Image
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

Re: SQL Error

Post by casanova »

What i done is from the old 3.0.0, I took a SQL dump of the data/structure and just pasted it into the new board once i installed it.

I didnt see 3.0.2, only saw 3.0.1 so downloaded that :/
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

Re: SQL Error

Post by casanova »

I just installed the 3.03, The newest board.

I exported my Data and Structure from the board (3.0.1) and then SQL Dumped it via phpmyadmin and i still get this problem.

i used phpmyadmin because the restore function was not working, it says its done but board didnt change.



SQL ERROR [ mysql4 ]

Unknown column 'user_new_privmsg' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

Re: SQL Error

Post by casanova »

Any one know the problem?
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

Re: SQL Error

Post by casanova »

.............................
User avatar
RMcGirr83
Former Team Member
Posts: 21693
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: SQL Error

Post by RMcGirr83 »

Did you run the sql update for 3.0.3? Download the auto installer, upload the install folder only then run the updater by visiting your board like so

Code: Select all

http://mysite.com/forum/install/database_update.php
See if that doesn't fix it.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

Re: SQL Error

Post by casanova »

Hey, I tried that already but no luck.

ps. this error only appears when a new register trys to register.

All current members can view and post and do everything but a no one else can register.

I can put in the Username/Password/Captha etc.. but when i click submit, thats the error i get.
User avatar
RMcGirr83
Former Team Member
Posts: 21693
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: SQL Error

Post by RMcGirr83 »

Well, that error says that it can't find that column in the user table so run this sql query in phpmyadmin and see if that fixes it.

Code: Select all

ALTER TABLE phpbb_users ADD user_new_privmsg int(4) DEFAULT '0' NOT NULL;
change phpbb to whatever your table prefix is.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
casanova
Registered User
Posts: 126
Joined: Wed Oct 01, 2003 12:28 pm

Re: SQL Error

Post by casanova »

Thanks.

That does now allow me to register

Will report back in a few days, hopefully the problem is solved.
Locked

Return to “[3.0.x] Support Forum”