Moving Server

stewpot007 · April 06, 2005, 09:33:04 AM

Hi,

Even after 5 hours of trying online and re-reading this thread over and over i can not transfer my forum to new webspace.

Here is the existing forum www.cr0.co.uk/curry

I took a download of the .sql database
the I want to transfer it to the new webspace, so i used phpmyadmin to try to upload the SQl, cant find the upload button anywhere in phpmyadmin, i finally find something to upload and i get an error back.

Is there a simpler way to do this for someone who knows nothing.
S

ItchyBanjo · April 07, 2005, 11:54:05 AM

Im having problems with importing the database, I get this error at the end of the sql restore

QuoteThere seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 5
STR: />
SQL: 
Warning: Cannot modify header information - headers already sent by (output started at /www.vehiclecommunication.com/ifitstuff/Sources/DumpDatabase.php:122) in /www.vehiclecommunication.com/ifitstuff/Sources/Subs.php on line 1754 
 
Warning: Cannot modify header information - headers already sent by (output started at /www.vehiclecommunication.com/ifitstuff/Sources/DumpDatabase.php:122) in /www.vehiclecommunication.com/ifitstuff/Sources/Subs.php on line 1755 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html><head>
 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
 <meta name="description" content="An Error Has Occurred!" />
 <meta name="keywords" content="PHP, MySQL, bulletin, board, free, open, source, smf, simple, machines, forum" />
 <script language="JavaScript" type="text/javascript" src="http://www.vehiclecommunication.com/ifitstuff/Themes/default/script.js"></script>
 <script language="JavaScript" type="text/javascript"><!--
 var smf_theme_url = "http://www.vehiclecommunication.com/ifitstuff/Themes/default"

What did I do wrong?

[EDIT] : I get the error "Table 'ifitstuf_newforum.smf_settings' doesn't exist" when I try to log into the forum now

Oldiesmann · April 08, 2005, 07:42:20 PM

Looks like the database dump didn't work properly and you just got a bunch of garbage instead...

[ASH]TGD · April 10, 2005, 01:32:28 PM

Ok. i need some help please.

I followed the first post on moving the DB and forums from one server to the next and runing the repair .php file. everything worked great! However, the new forum has the follows problems which I can seem to fix:

1. Smileys wont attach to the messages
2. bold, ubderline, etc functions on posting dont work
3. uploading avatars through he users profile manger doesnt work

Somethings did not come over on the first try like all my attachments and avatars ansd I had to re-do them, so mayble this is the same type problem, but I really don;t know where to go to fix.

If anyone can help me out it would be much apprciated.

Forum URL -
www.thegamedomain.org/tgdmain/

thanks!

Sloth_Boy · April 13, 2005, 08:11:18 AM

Quote from: mrichard on August 19, 2004, 10:37:30 AM
i am going to ask my webhost, that is 1and1.com maybe someone has an opinion about 1and1.com, i heard some but not related to this subject.
will let you know about my findings.

thank you man!
-richard
www.melpowerforum.com

Quote from first page!!!!

Um, if anyone wants to know a really really good hosting plan, then check out hostingplex.com, im with them and they are so good. 5000mb webspace, 110GB bandwidth, support for all script (bot sure about Coldfusion) and you can have 5 add-on domains and 20 sub-domains. Also, you can have 100MySQL databases. I looked aroudn for ever and this was the cheapest and best by far. Or, if you dont want all the fancy stuff and just want raw download bandwidth and space, then check out canaca.com, i havent been with them but there packages look alright (they dont include to many extras though, but have alot of bandwidth and space)

Anyway, i hope ive helped someone...

[Unknown] · April 16, 2005, 08:32:40 AM

Quote from: [ASH]TGD on April 10, 2005, 01:32:28 PM
1. Smileys wont attach to the messages
2. bold, ubderline, etc functions on posting dont work
3. uploading avatars through he users profile manger doesnt work

Sounds like path/javascript errors. I checkedc and your forum looks fine; still having issues?

-[Unknown]

wizboy · April 25, 2005, 02:44:51 PM

hi when i try to do this technique when i upload the sql file to the new server i get this error. anyone know [email protected]

Code Select

Error 
SQL-query: 

CREATE TABLE `smf_shop_items` (

id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
DESC varchar( 100 ) NOT NULL default '',
price decimal( 7, 2 ) unsigned NOT NULL default 0.00,
module tinytext NOT NULL default '',
stock smallint( 6 ) NOT NULL default 0,
PRIMARY KEY ( id ) 
) TYPE = MYISAM 
MySQL said:  

#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 'desc varchar(100) NOT NULL default '',
  price decimal(7,2) un

Politicitis · April 29, 2005, 05:47:47 AM

I moved my forum and am having issues.

- I moved from running thr forum from a directory on another domain to its own domain.
- the forum is still on the same server
- I've been told that I should not need to move the database because it is still on the same server with the same name and password
- I uploaded the files and had some issues, ran repair_settings.php but still have problems.

I do have a different plesk user and login than before.

Right now if I go to the forum all I see is "index" see www.politicitis.com/forum/index.php for an example. I have no idea what to do from here.

Politicitis · April 29, 2005, 03:59:02 PM

An update. Well it seems part of the problem was the file transfer, the files were all screwed up

Nothing like uploading garbage to screw things up.

The forum is there at least. There is no theme at all. www.politicitis.com/forum2 to see what I mean, it is all text.

I also get the following error when I log in:

Quote
2: file_exists(): open_basedir restriction in effect. File(/home/httpd/vhosts/bunktekforums.com/httpdocs/members/politicitis/forum/Themes/theme1/index.template.php) is not within the allowed path(s): (/home/httpd/vhosts/politicitis.com/httpdocs:/tmp)
/home/httpd/vhosts/politicitis.com/httpdocs/forum2/Sources/Load.php
822

I guess I need to run the repair_settings.php to fix the error. I'm just checking since my host/friend got it working to where it is and I don't want to screw up whatever he did.

Politicitis · April 30, 2005, 05:42:05 AM

Well, managed to get everything working.

Ended up that the files did not transfer to my pc and back up to the server properly and then being one line in the theme database pointing to the old location on the other domain.

[Unknown] · May 01, 2005, 03:43:27 AM

Quote from: wizboy on April 25, 2005, 02:44:51 PM
hi when i try to do this technique when i upload the sql file to the new server i get this error. anyone know [email protected]

I'm afraid this is caused by the shop mod. Edit the backup file and find:

desc var

Replace with:

`desc` var

-[Unknown]

Sys_ZERO · May 02, 2005, 06:17:58 AM

I cannot find an "import" button in PhpMyAdmin

Can anyone help me on this?

Thanks

[Unknown] · May 03, 2005, 12:56:51 AM

The SQL tab... under the database you want to import it into.

-[Unknown]

wizboy · May 04, 2005, 02:56:00 PM

I also managed to get everythign working my pc was just acting up.

Sys_ZERO · May 05, 2005, 01:12:35 AM

Quote from: [Unknown] on May 03, 2005, 12:56:51 AM
The SQL tab... under the database you want to import it into.

-[Unknown]

lol.. That was stupid of me not to find it

But thanks HEAPS

Sys_ZERO

lyrae · May 05, 2005, 09:52:12 AM

Quote from: Sloth_Boy on April 13, 2005, 08:11:18 AM
Or, if you dont want all the fancy stuff and just want raw download bandwidth and space, then check out canaca.com, i havent been with them but there packages look alright (they dont include to many extras though, but have alot of bandwidth and space)

This post is a couple of weeks old but my conscience compels me to alert anyone who's intrigued by Canaca to read my review of their "services" on the Hosts and Hosting forum.

raedzaro · June 04, 2005, 04:14:00 AM

Hi there

I moved my forum to another server all seems ok but I have a big problem with attachment.

some of old attachement available, while the rest of it availble at the attachmewnt forder but not linked with topics.

can any one advise what to do?

Ben_S · June 05, 2005, 01:56:09 PM

Did you upload them all to the new server?

raedzaro · June 06, 2005, 02:29:45 AM

Yes but my mistake was finalising setup before finishing upload all attachments

Now all Ok

pure · June 08, 2005, 09:57:13 AM

i wish i saw this thread before i changed my server...doh!
but i did the server change yesterday....everything went well but i too
have missing attachments.

they are uploaded to the same location, full path is correct in features and options and the dir is 777

old posts show 0 KB - downloaded X times
when i look at the source of the post i see
 filename.jpg

and when i try to post a new attachment i get " Cannot access attachments upload path!"

any ideas for a remedy? thanks

News:

Moving Server

Sys_ZERO

Sys_ZERO