Page 1 of 1
Gallery X 2
Posted: Wed Oct 22, 2008 4:11 pm
by Victorious
I really hate to sound "needy"
Problem number two..
www.daniellestratton.com/forum1, under the ACP, then under the MODS tab.. Why is there a Forum Gallery & Phpbb Gallery??? There is also 2 Manage Personal Albums - in the UCP under the Overview tab...
Thanks again for any help!
Re: Gallery X 2
Posted: Wed Oct 22, 2008 4:13 pm
by Sewell
Have you converted your board or is it a straight new install?
Re: Gallery X 2
Posted: Wed Oct 22, 2008 4:26 pm
by Victorious
I installed the board then about a week later I tried to convert it... I received errors so I deleted the board then did a new intall.
Re: Gallery X 2
Posted: Wed Oct 22, 2008 4:37 pm
by Sewell
It sounds like you didn't drop the old tables in database before installing your new board, would that be right?
It would make sense as it is showing two of them.
Re: Gallery X 2
Posted: Thu Oct 23, 2008 12:56 am
by Victorious
oh gosh.. I dont think I did. Is that something I could do now? Thank you so much for taking the time to help!
Re: Gallery X 2
Posted: Thu Oct 23, 2008 1:07 am
by LDM
Victorious, try it this way. Go into your database and drop all those tables, then re-import the sql again. Easiest way as you are just installing the forum there.
Re: Gallery X 2
Posted: Thu Oct 23, 2008 2:28 am
by Victorious
Hey LDM,
I dropped the tables then imported the upgrade sql. I received the following error:
Error
SQL query:
CREATE TABLE `phpbb_announcement_centre` (
`announcement_show` tinyint( 1 ) NOT NULL ,
`announcement_enable` tinyint( 1 ) NOT NULL ,
`announcement_enable_guests` tinyint( 1 ) NOT NULL ,
`announcement_show_birthdays` tinyint( 1 ) NOT NULL ,
`announcement_birthday_avatar` tinyint( 1 ) NOT NULL ,
`announcement_draft` text NOT NULL ,
`announcement_text` text NOT NULL ,
`announcement_text_guests` text NOT NULL ,
`announcement_title` varchar( 255 ) NOT NULL default '',
`announcement_title_guests` varchar( 255 ) NOT NULL default '',
`announcement_show_group` varchar( 255 ) NOT NULL default ''
) CHARACTER SET utf8 COLLATE utf8_bin
MySQL said:
#1064 - You have an error in your SQL syntax near 'CHARACTER SET utf8 COLLATE utf8_bin' at line 13
[ Back ]
Re: Gallery X 2
Posted: Thu Oct 23, 2008 1:24 pm
by LDM
Strange, could be your host is using an old MySQL version.
Did the other tables import okay?
Re: Gallery X 2
Posted: Mon Oct 27, 2008 8:15 pm
by Victorious
I'm so sorry for not answering this sooner.. family emergency.
I'm not sure about my host using an old version of MySQL and No, I dont see any tables.
Re: Gallery X 2
Posted: Wed Oct 29, 2008 6:03 pm
by LDM
So no other database tables were imported until you got that error?
Does it not work at all.
Re: Gallery X 2
Posted: Wed Oct 29, 2008 10:04 pm
by Victorious
After dropping the old tables I tried to re-import the sql file again and the error below is what I received while trying to import. No talbes were imported at all.
(of course when I try to go to the forum I receive this error now.)
General Error
SQL ERROR [ mysql ]
Table 'dsrforum.phpbb_config' doesn't exist [1146]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Re: Gallery X 2
Posted: Wed Oct 29, 2008 10:09 pm
by LDM
So you got that error on your browser while accessing the forum? All the tables haven't imported by the look of that, or the wrong details have been entered in the config.php - recheck that file.
Maybe an easier way to import is highlight and copy the modded.sql, then hit sql on that database and paste it into that window.