SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'u.user_id' in 'on clause' [1054]

SQL

SELECT u.user_id, u.username, u.user_type, u.group_id, u.user_colour, u.user_allow_viewonline, v.allow_viewonline, v.user_id, v.last_visit, b.bot_id FROM phpbb_users u, phpbb_visitors_today v LEFT JOIN phpbb_bots b ON (b.user_id = u.user_id) WHERE u.user_id = v.user_id ORDER BY u.user_type DESC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 132
CALL: dbal->sql_error()

FILE: includes/functions_visitors.php
LINE: 82
CALL: dbal_mysql->sql_query()

FILE: includes/functions.php
LINE: 3638
CALL: include('includes/functions_visitors.php')

FILE: index.php
LINE: 146
CALL: page_header()
I DONOO WHY SUDDENLY THIS ERROR IS COMEING. PLZ SOME ONE HELP PLZ...
AND I WISH TO INSTALL A NEW PHPBB3 AND ADD MY OLD DB TO IT CAN I ?
PLZ HELP I AM NEW TO THIS ALL ..
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

My host say he has updated the sql to 5 so that may be the prblem?
thienlong
Registered User
Posts: 32
Joined: Tue Sep 11, 2007 7:58 pm

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by thienlong »

did you installed any add on mods just before this error?
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

noo i dint
buut there was a error comeing in memberlist.php
and after somedays this happend suddenly

can i install a new phpbb3 and add the db there?
thienlong
Registered User
Posts: 32
Joined: Tue Sep 11, 2007 7:58 pm

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by thienlong »

which version of phpbb you currently have for the error board?
simple way is ...redownload a fresh copy phpbb (same version of your current board running) and upload to your host..
delete install/ folder
then copy config.php from old forum to this fresh version

....wait another 2 days for phpBB3 GOLD version or try current RC8 which is okie :)

http://www.phpbb.com/community/viewforum.php?f=65
check out that room for Converts information...
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

i tryed to install fresh copy of phpbb3
but some error again comeing
does sql5 supports phpbb3

this is the error i am getting

http://project-pirates.net/n/phpBB3/

Code: Select all

SQL ERROR [ mysql4 ]

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

SQL

SELECT image_name, image_filename, image_lang, image_height, image_width FROM phpbb_styles_imageset_data WHERE imageset_id = 5 AND image_lang IN ('en', '')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/session.php
LINE: 1481
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 26
CALL: user->setup()
thienlong
Registered User
Posts: 32
Joined: Tue Sep 11, 2007 7:58 pm

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by thienlong »

my board is currently on v5 .. and everything is fine :)
look like you have alot missing fields there ..
whats your old board version?
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

its old one of phpbb3 b5
b5
thienlong
Registered User
Posts: 32
Joined: Tue Sep 11, 2007 7:58 pm

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by thienlong »

http://www.megaupload.com/?d=IG1TAI7B
its RC8 fresh installed structures...
try that .. download that structures and alerts to mysql ..
prefix = phpbb_

try it w/ http://project-pirates.net/n/phpBB3/ see if it works..
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

i am done with makeing new db and installed
but how can i login i am getting some eorror

Code: Select all

General Error
You need to enter your password to access the Administration Control Panel.
is there any way chageing my style without login to admin panel
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by karlsemple »

You can use this script to reset back to prosilver
Image
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

BUDDY I AM DONE WITH EVERTHING BUT SMALL ERROR COMEING WHEN I EDIT A TOPIC
IF U CAN HELP ME IN THIS MY BOARD WILL BE PERFECT

Code: Select all

[phpBB Debug] PHP Notice: in file /posting.php on line 472: Undefined index: allow_post_flash
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3390: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2921)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3392: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2921)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3393: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2921)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3394: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2921)
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

plz last help buddy some one help me
:(
gautam39
Registered User
Posts: 18
Joined: Sat Dec 09, 2006 3:53 am
Location: India
Contact:

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by gautam39 »

plzz anyone
User avatar
Jim_UK
Former Team Member
Posts: 18480
Joined: Tue Oct 12, 2004 5:36 pm
Location: Darwen N.West UK

Re: SUDDENLY SOMETHING WENT WRONG? PLZ HELP

Post by Jim_UK »

There is no support for upgrades from Beta versions. That was made clear at the start - only for test purposes.

Support only for upgrades of RC versions.

This topic closed

Jim
The truth is out there.
Unfortunately they will not let you anywhere near it!
Locked

Return to “[3.0.x] Support Forum”