Author |
Message |
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 17:13:22
|
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]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 17:23:05
|
Carbonize
Master
![[Avatar]](/forum/images/avatar/96871336492d73e733f55.jpg)
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 |
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 17:36:46
|
hawkeye
Beginner
Joined: 19/01/2005 01:15:19
Messages: 21
Offline
|
so are you saying my backup is useless?
|
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 17:49:45
|
Carbonize
Master
![[Avatar]](/forum/images/avatar/96871336492d73e733f55.jpg)
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 |
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 17:57:20
|
Carbonize
Master
![[Avatar]](/forum/images/avatar/96871336492d73e733f55.jpg)
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 |
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 18:10:07
|
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]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 18:21:13
|
Carbonize
Master
![[Avatar]](/forum/images/avatar/96871336492d73e733f55.jpg)
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 |
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 18:23:30
|
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]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 18:26:51
|
Carbonize
Master
![[Avatar]](/forum/images/avatar/96871336492d73e733f55.jpg)
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 |
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 19:32:48
|
hawkeye
Beginner
Joined: 19/01/2005 01:15:19
Messages: 21
Offline
|
OK...but where is your email address?
thx
|
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 19:36:48
|
hawkeye
Beginner
Joined: 19/01/2005 01:15:19
Messages: 21
Offline
|
nevermind...I found it at your website in your signature...
|
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 21:08:04
|
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]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 21:21:41
|
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]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 21:23:34
|
Carbonize
Master
![[Avatar]](/forum/images/avatar/96871336492d73e733f55.jpg)
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 |
|
![[Post New]](/forum/templates/html/images/icon_minipost_new.gif) 06/02/2005 21:38:19
|
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
|
|
|