(solved)Problem restoring database (site is fine)

[shedt_v]

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: [url]http://[/url]

PHP Version: 4.4.7
MySQL Version:


What was done before the problem appeared?
nothing, installed XAMPP


What was done to try to solve the problem?
Backed up database (no g-zip) about 3 almost 4 megs. I tried to manually import it directly into mysql, but I am getting the same error.

Tried checking database for errors, optimize database, site is fine, but I want to transfer it over into XAMPP.



De.scription and Message

I'm following the tuturial for the XAMPP (which is great) install was fine, but I can't seem to restore the database.

I keep getting this:

Error

SQL query:

CREATE TABLE phpbb_force_read_users(
user varchar( 255 ) NOT NULL ,
READ int( 1 ) NOT NULL ,
time int( 10 ) NOT NULL
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read int(1) NOT NULL,
time int(10) NOT NULL
)' at line 3

that is through mysql. Integramod says something similar....


Any suggestions? I'm not that great with mysql but i am learning.

[shedt_v]

I'm deleting all the force read topic tables in the database. hope that will be ok, i don't use it anyways


edit-----



it worked!!!!

I'll leave this open before i change the title to solved, in case a admin/mod developer wants to tell me this will mess stuff up and i should not do it this way.




edit


maybe it's not working, it;'s forwarding me to the old domain. I guess I need to change it to the new one.

[Whisky]

maybe it's not working, it;'s forwarding me to the old domain. I guess I need to change it to the new one.

Classical issue when Restoring a phpbb/IM DB to another domain.

You have tio adapt your domain in your board configuration but you will not be able to navigate to your ACP and apply the change because it will always redirect to your old domain for very action you make.

The best way is to change it manually in the DB, you can run this query against your phpmyadmin, but do not forget to change the 'your_new_domain.com'

Code: Select all

UPDATE `phpbb_config`  SET  config_value = 'your_new_domain.com' WHERE  config_name = 'server_name'

After that go to your board config in ACP and adapt the cookie domain and all related stuff

[shedt_v]

yeah that's what i did to make it work, any comments on removing the force read topic tables from the database?

Now I just need to get XAMPP to work over the windows network.

Awesome stuff!