1
gnagis
changed server now wont work...
  • 2005/8/14 15:42

  • gnagis

  • Friend of XOOPS

  • Posts: 40

  • Since: 2004/1/11


i changed server from a linux host to a windows host... i have copyed all MySQL tabels and data to new db and changed everything in mainfile.php is ther anything else??

becouse now thers only 1000 errors and nothing showing up :S ??


http://smartphone.torgplatsen.se

this is the page :S
|||->ALL YOUR BASE ARE BELONG TO US<-|||

2
rowdie
Re: changed server now wont work...
  • 2005/8/14 17:20

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


Two suggestions...

- check again to make sure the [prefix]_config database table has been copied - and the data, of course...

- make sure the templates_c, uploads, and cache folders are writeable.

3
gnagis
Re: changed server now wont work...
  • 2005/8/14 20:21

  • gnagis

  • Friend of XOOPS

  • Posts: 40

  • Since: 2004/1/11


It says error on this:

CREATE TABLE xoops_block_instance (
instanceid int(12) unsigned NOT NULL auto_increment,
bid int(12) unsigned NOT NULL default '0',
options text NOT NULL,
title varchar(255) NOT NULL default '',
side tinyint(1) unsigned NOT NULL default '0',
weight smallint(5) unsigned NOT NULL default '0',
visible tinyint(1) unsigned NOT NULL default '0',
bcachetime int(10) unsigned NOT NULL default '0',
PRIMARY KEY (instanceid),
KEY join (instanceid,visible,weight)
) TYPE=MyISAM;


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 'join (instanceid,visible,weight) )' at line 1
|||->ALL YOUR BASE ARE BELONG TO US<-|||

4
rowdie
Re: changed server now wont work...
  • 2005/8/14 22:06

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


Export that table again from your original database, this time use the option 'Enclose table and field names with backquotes' (assuming you use phpMyAdmin).

Or just add backquotes around the word `join` (as I just did ).

5
gnagis
Re: changed server now wont work...
  • 2005/8/14 23:01

  • gnagis

  • Friend of XOOPS

  • Posts: 40

  • Since: 2004/1/11


whell that dident change anything.. the site still says a bunch of errors... anyone know yet what it can be ??


www.smart-resource.com <-- press the picture and you will get there
|||->ALL YOUR BASE ARE BELONG TO US<-|||

6
jdseymour
Re: changed server now wont work...

Are you getting any errors from the database when inserting the data? I think it is a files problem not a database problem.

7
skalpa
Re: changed server now wont work...
  • 2005/8/14 23:12

  • skalpa

  • Quite a regular

  • Posts: 300

  • Since: 2003/4/16


Well, I'm not sure... but: you should not transfer the content of the cache/ and templates_c/ folders to the new server...
So if you did, try deleting these folders content (except the index.html file that should be in each of them), and see if that fixes something.

skalpa.>
Any intelligent fool can make things bigger, and more complex. It takes a touch of genius, a lot of courage, to move in the opposite direction.
Two things are infinite: the universe and human stupidity; and I'm not sure about the 1st one (A.Einstein)

8
rowdie
Re: changed server now wont work...
  • 2005/8/14 23:37

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


I've seen that refreshing problem before - you didn't run the install script again on that site by any chance, did you?

9
gnagis
Re: changed server now wont work...
  • 2005/8/15 8:16

  • gnagis

  • Friend of XOOPS

  • Posts: 40

  • Since: 2004/1/11


No i did NOT install again just copied everything emptied the cache and template_c folders and changed the mainfile.php


thats everything i have done :S
|||->ALL YOUR BASE ARE BELONG TO US<-|||

10
jdseymour
Re: changed server now wont work...

Seems not to be constantly reloading now. Any other problems?

Login

Who's Online

166 user(s) are online (112 user(s) are browsing Support Forums)


Members: 0


Guests: 166


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits