| Welcome Visitor, Please Login or Register Now |
|
Wednesday, February 05, 2025 06:56 PM |
 |
Focusman01  |
| Registered Member |
Posts: 118  |
| Joined: 02-05-25 06:56 PM |
|
|
|
 |
  |
|
| |
 |
|
| After transfering to new server .gif and database problems |
Edit Delete   Quote |
| First Post Posted on: 10-17-10 07:31 AM |
  |
|
|
Hello Ahmed
Since moving to new server .gif files are very distorted, Look like someone used a wet paint brush to blend all of the colors of a rainbow together both on admin and user side and images are bunch tight together on user side. I used binary mode to upoad .gif, three times, still same result.
How can this be fixed?
In regard to the database, I did as instructed:
from your admin->database & sql manager, click on:
Backup SQL Database Into Text Files
this will backup your database in the files under the directory data/database.
download all the directory data/database (in ascii mode) to your local computer.
Install or move the classifieds software on your new server, then upload
the directory data/database (in ascii mode) to your new classifieds
Now go to your new host admin->database & sql manager, click on
Load SQL Database From The Text Files Backup
This was the end result:
SQL Error
SQL Error: Column count doesn't match value count at row 1
Query:
INSERT INTO Ads_Categories VALUES('40','11','1','1','0','0<~')
Line 895, File /xxxxx/local/home/xxxxx/xxxxxxxx.com/cgi-bin/class1/DatabaseMgr.pm.
This was mention before, figure on new server it would transfer 100% of file, but the same thing within Ads_Categories.sql.pm after downloading from old server there are 65 lines of code. But everytime you tried to upload to server only 40 lines of the 65 are transfered. CuteFtppro send message after 63% of Ads_Categories.sql.pm is uploaded, unable to upload and then it attempt again stops at 63% over and over until disconnected. It tried 6 times, same message.
If you have time would you please try to repeat the steps with demo, that is delete Ads_Categories.sql.pm and ftp it back to see if you come up with less lines of code.
I know somtehing wasn't done properly by me. Just don't know what.
Would like your opinion on how to fix errors, before updating classifiedawy or starting over from scratch.
Thank you for your time. |
|
|
|
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 02-05-25 06:56 PM |
| Location: knxoville, TN, USA |
 |
|
|
     |
|
| |
|
|
|
|
| Anonymous |
| Registered Member |
| Posts: |
| Joined: 02-05-25 06:56 PM |
|
|
|
|
| PM |
|
| |
|
|
| Re: After transfering to new server .gif and database problems |
Edit Delete Quote |
| Reply #: 2 Posted on: 10-17-10 09:37 AM |
 |
|
|
I don't know if this will help or not, but I had a similar problem once before because I had installed my software on a FreeBSD server. I had the host upgrade to the latest version of GD and it still didn't fix it. My pictures were spotted and grainy.
I then had the same hosting company move me to a Redhat Linux server and everything was fine after that.
I'm not sure if this applies here, or if FreeBSD was the problem, but I thought I would mention this. |
|
|
|
|
|
| Focusman01 |
| Registered Member |
| Posts: 118 |
| Joined: 02-05-25 06:56 PM |
|
|
|
|
| |
|
| |
|
|
|
|
| Focusman01 |
| Registered Member |
| Posts: 118 |
| Joined: 02-05-25 06:56 PM |
|
|
|
|
| |
|
| |
|
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 02-05-25 06:56 PM |
| Location: knxoville, TN, USA |
|
|
|
| |
|
| |
|
|
| Re: After transfering to new server .gif and database problems |
Edit Delete Quote |
| Reply #: 5 Posted on: 10-19-10 05:36 AM |
 |
|
|
|
|
|
|
| |
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.3257 Seconds |
|
for those who don't know how to use consol or Telnet, what is the best ftp program to use with your software?