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
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
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]
hawkeye
Beginner

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

so are you saying my backup is useless?
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]
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]
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
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]
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...
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]
hawkeye
Beginner

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

OK...but where is your email address?

thx
hawkeye
Beginner

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

nevermind...I found it at your website in your signature...
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
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...
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]
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