Main Menu
Our Sponsors
Chi Kien Uong
Geranienstraße 30
71034 Böblingen
Deutschland / Germany
If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register /  [Login] Login 
Importing data from older version?  XML
Forum Index » Support Forum
Author Message
[Post New]06/02/2005 17:13:22
    Subject: Importing data from older version?
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
I have the previous version of the guestbook (the most recent before the current one) and when I try to import the data from the backup I get this error in MyPHPadmin:

#1136 - Column count doesn't match value count at row 1

Anyone tell me how to fix this?

Thx
[Post New]06/02/2005 17:23:05
    Subject:
[Up]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
This is because 2.3.1 has more fields in it than 2.2 did.
Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
[Post New]06/02/2005 17:36:46
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
so are you saying my backup is useless?
[Post New]06/02/2005 17:49:45
    Subject:
[Up]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
no, you could delete the entrie book_* tables that you installed with 2.3.1 then install your 2.2 backup. Then use my upgrade script.
Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
[Post New]06/02/2005 17:57:20
    Subject:
[Up]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
You could always stick with version 2.2. I see no major reason to upgrade.
Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
[Post New]06/02/2005 18:10:07
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
2.3.1 is the version that my host offers...I am not sure if you remember but I was hacked a few weeks ago and I asked if there was a way to recover my data. Well I found a backup I did in July so all would not be lost. Only a few entries would be gone...

What do you mean by upgrade script? If I am already running the latest version what will I be updating?

Thx
[Post New]06/02/2005 18:21:13
    Subject:
[Up]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
Yes it is confusing then. How did you do the backup? phpMyAdmin?
Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
[Post New]06/02/2005 18:23:30
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
I used cPanel backup to back up the whole site...I have a SQL file for each of my databases...

I tried just putting in the "Insert" portions via phpMYadmin but that did not work...that's how I got the error...
[Post New]06/02/2005 18:26:51
    Subject:
[Up]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
If you have no objection could you email me what you were trying to insert. thank you.
Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
[Post New]06/02/2005 19:32:48
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
OK...but where is your email address?

thx
[Post New]06/02/2005 19:36:48
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
nevermind...I found it at your website in your signature...
[Post New]06/02/2005 21:08:04
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
Carbonize,

for some reason I can't send any emails with hotmail...herei s my reply to your last email:

So what can I do about it? This is how the back up was made using phpMYadmin and I did not alter anything...is there a way to "fool" phpMYadmin to thinking the extra field is there?

Thx
[Post New]06/02/2005 21:21:41
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
Carbonize,

Hotmail is down for some reason. I can't download nor send emails with it? I saw your email come in via msn messenger but I can't access it.

If what you sent can be posted here that would be great...
[Post New]06/02/2005 21:23:34
    Subject:
[Up]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
carbonize@hotmail.com - message me
Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
[Post New]06/02/2005 21:38:19
    Subject:
[Up]
hawkeye
Beginner

Joined: 19/01/2005 01:15:19
Messages: 21
Offline
Sorry carbonize...I am getting the same error:

#1136 - Column count doesn't match value count at row 1
 
Forum Index » Support Forum
Go to:   
Based on the open source JForum