local convert, bigdump and 500 errors

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
ember1
Registered User
Posts: 20
Joined: Fri Aug 21, 2009 2:51 am

local convert, bigdump and 500 errors

Post by ember1 »

howdy all,
i am attempting a conversion from 2.x to 3.x; however, i kept getting 500 errors. (my host is godaddy, so if anyone knows specific errors that i can resolve with them, please let m know.) i read up a good bit and it appears that the resolution is to do a local conversion. i am in the midst of trying to do the local conversion and when trying to use big dump to load up the back up sql file i get the error below. locally i am using:
apache 2.3; mysql 5.1.37; php 5.3. thanks!
Error at the line 45: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Query: --
--
--
--
CREATE TABLE `phpbb_auth_access` (
`group_id` mediumint(8) NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`auth_view` tinyint(1) NOT NULL default '0',
`auth_read` tinyint(1) NOT NULL default '0',
`auth_post` tinyint(1) NOT NULL default '0',
`auth_reply` tinyint(1) NOT NULL default '0',
`auth_edit` tinyint(1) NOT NULL default '0',
`auth_delete` tinyint(1) NOT NULL default '0',
`auth_sticky` tinyint(1) NOT NULL default '0',
`auth_announce` tinyint(1) NOT NULL default '0',
`auth_vote` tinyint(1) NOT NULL default '0',
`auth_pollcreate` tinyint(1) NOT NULL default '0',
`auth_attachments` tinyint(1) NOT NULL default '0',
`auth_mod` tinyint(1) NOT NULL default '0',
KEY `group_id` (`group_id`),
KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

MySQL: Table 'phpbb_auth_access' already exists

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50984
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: local convert, bigdump and 500 errors

Post by stevemaury »

Are you using xampp? I assume you are trying to import the version 2 database to the local version 2 installation?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

ember1
Registered User
Posts: 20
Joined: Fri Aug 21, 2009 2:51 am

Re: local convert, bigdump and 500 errors

Post by ember1 »

i am indeed trying to import version 2 database to the local version 2 installation. i am using easyphp, not xampp.
thanks.

ember1
Registered User
Posts: 20
Joined: Fri Aug 21, 2009 2:51 am

Re: local convert, bigdump and 500 errors

Post by ember1 »

i dropped all tables from the old database, it seems to be working now.

Locked

Return to “[3.0.x] Support Forum”