phpBB • Free and Open Source Forum Software

it brings that message back in about 20 seconds after I start the conversion.

Hub

The hosting company was able to fix the issue with the offending table.

Thanks.

Hub

I am trying to convert my phpbb 2.0.22 to 3.0.1 and I get this error when running the covert utility. General Error SQL ERROR [ mysql4 ] MySQL server has gone away [2006] SQL SELECT MAX(forum_id) AS max_forum_id FROM phpbb_forums BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal->sql_error(...

Where would I run that from? Kinda new.

Hub

SQL Error : 145 Table './hubmonke_xmb1/phpbb_search_wordlist' is marked as crashed and should be repaired I have ran the repair utility from the MySQL AND I have ran the fixtables.php script and still the same thing. I cannot nor can any of my members post new tpics. I have engaged my webhost's supp...

Is there a way to delete all the users that have not registered? I have used the search but came up empty.

Hub

I think I have fixed my Cookie issues as well... Thanks for the Assistance!

Now onto the next issue.

Hub

So now you just have the login issues correct? Knowledge Base - Fixing cookie/domain/script path settings If you still have a problem after following the instructions in the article, please post back with your new cookie settings. (You can copy it from the box in the MOD). Yes the Visual Confirmati...

Okay... Well I feel really stupid now... I was working off the wrong database... it is supposed to be the XMB1 and not the PHPB1... geez... Here is the results after doing the previous strings.... Required table phpbb_auth_access has all required fields Required table phpbb_user_group has all requir...

These are the options in myphpadmin....

hubmonke_gallery
hubmonke_imga1
hubmonke_phpb1
hubmonke_poll1
hubmonke_xmb1

The Bold one is the one I have been working off of.


Hub

I think it is really jacked up because I have to login 2 times in order to get logged in, it does not keep me logged in (even though I have it turned on in the configuration) and when I try to find posts people have made by clicking on their profile it errors out.

Hub

Ran that query and this is what I received... Ran that query and this is what I received... Error SQL query: ALTER TABLE phpbb_search_results ADD COLUMN search_time int( 11 ) DEFAULT '0' NOT NULL ; MySQL said: #1060 - Duplicate column name 'search_time' Ran the test and this is what I received.... R...

Now that it says the table already exists, do you get the same results when you run the test script? There are several other things missing from your tables, and it would appear that the update_to_latest.php script has been skipped more than once in the past history of your board... The results are...

Okay I did the Query and this is what I got.... Error SQL query: # # Table structure for table 'phpbb_confirm' # CREATE TABLE phpbb_confirm( confirm_idchar( 32 ) DEFAULT '' NOT NULL , session_idchar( 32 ) DEFAULT '' NOT NULL , codechar( 6 ) DEFAULT '' NOT NULL , PRIMARY KEY ( session_id, confirm_id ...

Okay so I did the query and it comes back with a blank white screen. I re-ran the Validate PHP script and get this... Required table phpbb_auth_access has all required fields Required table phpbb_user_group has all required fields Required table phpbb_groups has all required fields Required table ph...