Author Topic: change url and/or server; Move 4images to new server  (Read 44089 times)

0 Members and 1 Guest are viewing this topic.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: change url and/or server; Move 4images to new server
« Reply #30 on: March 12, 2005, 08:12:48 PM »
actualy for me its easier just open the exported .sql file in any text editor (even notepad would work) and chop it down on many little pieces.
Another alternative is download some mysql manager software (I've tryed Navicat) which can import/export any size queries.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Re: change url and/or server; Move 4images to new server
« Reply #31 on: March 13, 2005, 12:54:07 AM »
Thanks, chopping up worked. Since the wordmatch was all single entries, although the size is not the same at the end,

Format:      fixed
Rows:    21,445
Row length ø:    10
Row size  ø:    22 Bytes

against

Format  :    fixed
Rows:    21,445
Row length ø:    10
Row size  ø:    21 Bytes

hopefully the row size will not make difference ?

These match:
 image_word_id  --    UNIQUE  --    21445
 image_word_id  --    UNIQUE --     21445


Addition:
It seems like Windows search is having problem finding the db name in .php files in /4images.

I will check it once again, but maybe the whole word matching might be the problem. Will look for 3rd party search tool with powerful file reading options.

thanks


Please Vote for my site: Here

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Re: change url and/or server; Move 4images to new server
« Reply #32 on: March 13, 2005, 04:38:48 AM »
Just to confirm one quick thing and to make this a topc where everyone can easily move their 4images  site in its entirety, I just edited my previous step by step instruction.

I just did it, and it works great.

original site:
http://www.34tr.com

backed up site:
http://s116975426.onlinehome.us/4images/

enjoy, and please let me know if you see anything acting up. ;)

Please Vote for my site: Here

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: change url and/or server; Move 4images to new server
« Reply #33 on: March 13, 2005, 05:01:40 AM »
a quick note:
if u going to "chop" the .sql file, then u can remove any INSERT INTO 4images_wordmatch VALUES ()
and then use this plugin instead:
http://www.4homepages.de/forum/index.php?topic=1096.0
also, sessions and session_vars inserts dont needed
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Re: change url and/or server; Move 4images to new server
« Reply #34 on: March 13, 2005, 07:50:23 PM »
hi v@no,

so with this setup, we don't really need 4images_wordmatch at all right, as long as it has only one or if we really don't need search stats? I am kind of confused what wordmatch does.

Thanks.

Please Vote for my site: Here

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: change url and/or server; Move 4images to new server
« Reply #35 on: March 13, 2005, 07:56:04 PM »
well, what I was trying to say is there is a plugin that rebuilds search index (wordmatch) so, why whould u waste your time on importing the search index if u can do it with the plugin?
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline Michael H

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: change url and/or server; Move 4images to new server
« Reply #36 on: June 14, 2005, 10:40:50 AM »
Hello.

I have just moved 4images v.1.7 to a new server and everything, but one thing, seems to work.

That one thing, is that i can´t upload new pictures ? Every time I try it tells me to:

Please recheck the marked fields - and its the image upload field.

All chmod should be in order.

I can import pictures using ftp and check new images.

Offline Michael H

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: change url and/or server; Move 4images to new server
« Reply #37 on: June 15, 2005, 02:03:17 PM »
Problem solved - it was an setup error at my host.

Offline poca

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: change url and/or server; Move 4images to new server
« Reply #38 on: June 30, 2005, 11:26:22 PM »
I moved to a new server, tried to backup from the admin panel, said ok, nothing really happened.
Came here, found the forumtopic, read it all. Did everything as told and still got the following error:
DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
Table 'graffiti.4images_settings' doesn't exist

I had to change the db name, cause the new server provider doesnt support _ character. Changed it in backup.sql and config.php, couldnt though find any other php files with db name in it. Or is there?
tnks

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: change url and/or server; Move 4images to new server
« Reply #39 on: July 01, 2005, 07:10:01 AM »
check includes/constants.php
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline poca

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: change url and/or server; Move 4images to new server
« Reply #40 on: July 01, 2005, 09:23:34 AM »
checked, nothing there.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: change url and/or server; Move 4images to new server
« Reply #41 on: July 01, 2005, 02:43:36 PM »
well, I have no idea what u've changed in the .sql file, but obviosly your backup copy does not create 4images_settings table in the database.

make sure u've changed table names (if u did) with a prefix that matched with $table_prefix in config.php
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline blitzy

  • Newbie
  • *
  • Posts: 32
    • View Profile
    • http://www.cs-media.org
Re: change url and/or server; Move 4images to new server
« Reply #42 on: December 21, 2005, 07:49:20 AM »
I just moved my gallery from one server to a new one and re-installed 4images. I want all of my old settings and users set on the new server so I followed the instructions to upload the backup SQL file in phpMyAdmin. However, near the end, I get this error message:

Code: [Select]
Error

SQL query:

CREATE TABLE 4images_categories(
cat_id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
cat_name varchar( 255 ) NOT NULL default '',
cat_description text NOT NULL ,
cat_parent_id int( 10 ) unsigned NOT NULL default '0',
cat_hits int( 10 ) unsigned NOT NULL default '0',
cat_order int( 10 ) unsigned NOT NULL default '0',
auth_viewcat tinyint( 2 ) NOT NULL default '0',
auth_viewimage tinyint( 2 ) NOT NULL default '0',
auth_download tinyint( 2 ) NOT NULL default '0',
auth_upload tinyint( 2 ) NOT NULL default '0',
auth_directupload tinyint( 2 ) NOT NULL default '0',
auth_vote tinyint( 2 ) NOT NULL default '0',
auth_sendpostcard tinyint( 2 ) NOT NULL default '0',
auth_readcomment tinyint( 2 ) NOT NULL default '0',
auth_postcomment tinyint( 2 ) NOT NULL default '0',
sort_order varchar( 5 ) NOT NULL default 'ASC',
sort_field varchar( 20 ) NOT NULL default 'image_name',
PRIMARY KEY ( cat_id ) ,
KEY cat_parent_id( cat_parent_id ) ,
KEY cat_order( cat_order )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

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 'DEFAULT CHARSET=latin1' at line 22

My new host (AN Hosting) uses phpMyAdmin 2.6.4.

Please help!

Offline unite

  • Newbie
  • *
  • Posts: 48
    • View Profile
Re: change url and/or server; Move 4images to new server
« Reply #43 on: July 10, 2006, 04:25:35 AM »
For those of you having problems with your host, I will install the script for free and host it for $6.95 a month. Send me a PM if your interested. www.web-rocket.com