Gallery X 2

Post any general problems, information or issues on ModphpBB3 in here.
Post Reply
Victorious
Forum Member
Forum Member
Posts: 8
Joined: Sat Sep 13, 2008 12:56 am

Gallery X 2

Post by Victorious » Wed Oct 22, 2008 4:11 pm

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!

User avatar
Sewell
Forum Member
Forum Member
Posts: 113
Joined: Mon Jul 28, 2008 11:40 am

Re: Gallery X 2

Post by Sewell » Wed Oct 22, 2008 4:13 pm

Have you converted your board or is it a straight new install?

Victorious
Forum Member
Forum Member
Posts: 8
Joined: Sat Sep 13, 2008 12:56 am

Re: Gallery X 2

Post by Victorious » Wed Oct 22, 2008 4:26 pm

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.

User avatar
Sewell
Forum Member
Forum Member
Posts: 113
Joined: Mon Jul 28, 2008 11:40 am

Re: Gallery X 2

Post by Sewell » Wed Oct 22, 2008 4:37 pm

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.

Victorious
Forum Member
Forum Member
Posts: 8
Joined: Sat Sep 13, 2008 12:56 am

Re: Gallery X 2

Post by Victorious » Thu Oct 23, 2008 12:56 am

oh gosh.. I dont think I did. Is that something I could do now? Thank you so much for taking the time to help!

User avatar
LDM
Site Admin
Site Admin
Posts: 1794
Joined: Thu May 29, 2008 6:51 pm

Re: Gallery X 2

Post by LDM » Thu Oct 23, 2008 1:07 am

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.

Victorious
Forum Member
Forum Member
Posts: 8
Joined: Sat Sep 13, 2008 12:56 am

Re: Gallery X 2

Post by Victorious » Thu Oct 23, 2008 2:28 am

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 ]

User avatar
LDM
Site Admin
Site Admin
Posts: 1794
Joined: Thu May 29, 2008 6:51 pm

Re: Gallery X 2

Post by LDM » Thu Oct 23, 2008 1:24 pm

Strange, could be your host is using an old MySQL version.

Did the other tables import okay?

Victorious
Forum Member
Forum Member
Posts: 8
Joined: Sat Sep 13, 2008 12:56 am

Re: Gallery X 2

Post by Victorious » Mon Oct 27, 2008 8:15 pm

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.

User avatar
LDM
Site Admin
Site Admin
Posts: 1794
Joined: Thu May 29, 2008 6:51 pm

Re: Gallery X 2

Post by LDM » Wed Oct 29, 2008 6:03 pm

So no other database tables were imported until you got that error?
Does it not work at all.

Victorious
Forum Member
Forum Member
Posts: 8
Joined: Sat Sep 13, 2008 12:56 am

Re: Gallery X 2

Post by Victorious » Wed Oct 29, 2008 10:04 pm

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.

User avatar
LDM
Site Admin
Site Admin
Posts: 1794
Joined: Thu May 29, 2008 6:51 pm

Re: Gallery X 2

Post by LDM » Wed Oct 29, 2008 10:09 pm

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.

Post Reply