MySQL Trouble

Having trouble installing ModphpBB3 - Post any questions or issues in here.
Post Reply
live2worship
Forum Member
Forum Member
Posts: 4
Joined: Fri Feb 06, 2009 5:09 am

MySQL Trouble

Post by live2worship »

After following install inst. go to login and i get

SQL ERROR [ mysql4 ]

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

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Can anyone help me get this goin?

It's a fresh install
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: MySQL Trouble

Post by LDM »

I haven't seen that error on install before, can you post your URL.
live2worship
Forum Member
Forum Member
Posts: 4
Joined: Fri Feb 06, 2009 5:09 am

Re: MySQL Trouble

Post by live2worship »

sorry, i'm trying to get it to work in this test folder before i move to main domain.

Code: Select all

http://www.repairallmakes.com/test
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: MySQL Trouble

Post by LDM »

Did you fill in the blank fields in the config.php with your database info?

An error like that would relate to the config.php I reckon.
live2worship
Forum Member
Forum Member
Posts: 4
Joined: Fri Feb 06, 2009 5:09 am

Re: MySQL Trouble

Post by live2worship »

Yes i did, i followed the instructions fairly simply, i think it might have something to do with importing to phpmyadmin
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: MySQL Trouble

Post by LDM »

I'm not sure as I haven't seen that error before.

If your config is alright, drop the tables via phpmyadmin and re-import it again.
live2worship
Forum Member
Forum Member
Posts: 4
Joined: Fri Feb 06, 2009 5:09 am

Re: MySQL Trouble

Post by live2worship »

i'm sorry i really do'nt know what you mean by drop the tables, if you can give me a lil direction i would greatly appreciate it.

Also do you know if i can apply any skin to this moddedphpbb, or does it have to be a moddedphpbb style


Thanks again i appreciate it...
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: MySQL Trouble

Post by LDM »

You go into your database, click on the phpBB database, select all tables, then drop.
Click on Import after and re-import the SQL.

Any style will work but you won't see the most of mods on the board unless you use one of our edited for ModphpBB3 styles (for your version) or add the template edits to your style used.
muppet-modding
Forum Member
Forum Member
Posts: 18
Joined: Sat Mar 07, 2009 2:05 am

Re: MySQL Trouble

Post by muppet-modding »

having a similar issue installing 1.0.5

well the install of modphp was fine, the database install isn't so fine, lol

we recently moved over from mybb to phpbb3, conversion went well but wasn't happy with the system, i then found your site and decided this is the way to go but am having these errors after installing db

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown database 'muppettest' [1049]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
the url for the modded forum is as follows:
http://muppet-modding.com/mod/

we still have our normal forums up but are pretty eager to get your system up asap,

thanks - ...BeAkEr...
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: MySQL Trouble

Post by LDM »

It's the config.php by the looks, there may be a wrong edit on it pointing to the database.

Edit: Actually I just spotted you have a phpBB in the root, remember you can't just point it to that database. You will need to convert that board with the files and sql queries.
muppet-modding
Forum Member
Forum Member
Posts: 18
Joined: Sat Mar 07, 2009 2:05 am

Re: MySQL Trouble

Post by muppet-modding »

thank you, i will look into it and tell you how i got on
muppet-modding
Forum Member
Forum Member
Posts: 18
Joined: Sat Mar 07, 2009 2:05 am

Re: MySQL Trouble

Post by muppet-modding »

we're up and running now thanks, just the gallery is giving us problems, what do you think?


http://muppet-modding.com/gallery/index ... f9e740f320
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: MySQL Trouble

Post by LDM »

That error looks to me like one of the old files from the phpBB is still on the server and that the changes in the Modded phpBB3 file are not seen.
muppet-modding
Forum Member
Forum Member
Posts: 18
Joined: Sat Mar 07, 2009 2:05 am

Re: MySQL Trouble

Post by muppet-modding »

do you think that could be causing/affecting my admin problem?
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: MySQL Trouble

Post by LDM »

Yes as I haven't seen that before on a converted board. It may do that until you delete board cookies and then it's fine, where as yours is on a loop as you say.

Maybe session.php
Post Reply