Page 1 of 1

MySQL Trouble

Posted: Fri Feb 06, 2009 5:50 am
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

Re: MySQL Trouble

Posted: Fri Feb 06, 2009 1:33 pm
by LDM
I haven't seen that error on install before, can you post your URL.

Re: MySQL Trouble

Posted: Fri Feb 06, 2009 3:50 pm
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

Re: MySQL Trouble

Posted: Fri Feb 06, 2009 4:10 pm
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.

Re: MySQL Trouble

Posted: Fri Feb 06, 2009 6:52 pm
by live2worship
Yes i did, i followed the instructions fairly simply, i think it might have something to do with importing to phpmyadmin

Re: MySQL Trouble

Posted: Fri Feb 06, 2009 7:28 pm
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.

Re: MySQL Trouble

Posted: Fri Feb 06, 2009 10:45 pm
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...

Re: MySQL Trouble

Posted: Sun Feb 08, 2009 8:38 pm
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.

Re: MySQL Trouble

Posted: Mon Mar 09, 2009 10:48 pm
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...

Re: MySQL Trouble

Posted: Tue Mar 10, 2009 12:35 am
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.

Re: MySQL Trouble

Posted: Tue Mar 10, 2009 1:43 am
by muppet-modding
thank you, i will look into it and tell you how i got on

Re: MySQL Trouble

Posted: Thu Mar 12, 2009 9:15 pm
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

Re: MySQL Trouble

Posted: Thu Mar 12, 2009 11:14 pm
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.

Re: MySQL Trouble

Posted: Thu Mar 12, 2009 11:20 pm
by muppet-modding
do you think that could be causing/affecting my admin problem?

Re: MySQL Trouble

Posted: Thu Mar 12, 2009 11:27 pm
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