How to fix problem in db?
Asked Modified Viewed 15,919 times
asked
Hi
How to fix this problem?
Column count doesn't match value count at row 1
Showes on screen while trying to infuse calender 2.0 after having defused calender 1.0
How to fix this problem?
Column count doesn't match value count at row 1
Showes on screen while trying to infuse calender 2.0 after having defused calender 1.0
answered
Right B)
Calendar v2.0
Calendar v2.0
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
Hmm, cannot expand rar files on my Mac :|
answered
Hold on...
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
fixed
answered
ok :)
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
Just a hunch: in infusion.php see if it helps to changeto.
Code Download source
$inf_link_visibility = "0";Code Download source
$inf_link_visibility = "";Edited by muscapaul on 02-05-2006 14:41,
answered
Didnt help... also the calendar v2.0 works just fine, as it is, on another of my homepages. You can see it here
Im having trouble at this homepage
Im having trouble at this homepage
Edited by langkawi on 02-05-2006 15:20,
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
I just fails at the infusion stage? Have you any other significant modifications/infusions on the problematic site?
answered
Quote
Its says nothing at all :o
No infusion... how to install this? Maybe I did wrong...
Read the read me ;)
This is not an infusion, its the admin panel to infuse infusions.
Backup your current administrations/inusions.php
Extract and upload the one in the tar file.
See what the message is when you attempt to infuse the calender after that
CJ
answered
calendar-2.0.rar infuses and defuses just fine on one of my test sites.
My best guess is that you have one or two leftover tables from the v. 1.0 with the same names as for the v. 2.0.
v. 2.0 installs these tables if you use fusion_ as prefix:
fusion_kalender
fusion_kalender_settings
Backup those tables in phpMyadmin if they exist and you wish to keep the data in the tables. Then delete the tables in phpMyadmin and try to infuse the v. 2.0 once again.
My best guess is that you have one or two leftover tables from the v. 1.0 with the same names as for the v. 2.0.
v. 2.0 installs these tables if you use fusion_ as prefix:
fusion_kalender
fusion_kalender_settings
Backup those tables in phpMyadmin if they exist and you wish to keep the data in the tables. Then delete the tables in phpMyadmin and try to infuse the v. 2.0 once again.
Reflectoman
Reflectoman 10
------------------------------------------------
Adnan Ahmed Online
File Hosting | Image Hosting | Free SMS
Adnan Ahmed Online
File Hosting | Image Hosting | Free SMS
- Member, joined since
- Contributed 176 posts on the community forums.
- Started 9 threads in the forums
@WEC_Admin - i asked him to do that ... and he did. defused it, and made sure the tables were dropped from phpmyadmin.
i just dont' understand why its failing on one of your site and not the other ... did u do any changes to the files on this server? any modification at all?
the error isnt it due to a query that's adding one column too much or not enough infroamtion in its insert or update? how would changing a value form 0 to none, solve this?
i'm also learning php as i work with this system, so every bit of knowledge helps! :D
i just dont' understand why its failing on one of your site and not the other ... did u do any changes to the files on this server? any modification at all?
the error isnt it due to a query that's adding one column too much or not enough infroamtion in its insert or update? how would changing a value form 0 to none, solve this?
i'm also learning php as i work with this system, so every bit of knowledge helps! :D
answered
Then it's one of the other tables that is updated by the infusion that is causing trouble and the site causing trouble might not be properly updated. Was it updated from a very early version of PHPFusion? Maybe a core db update was overlooked back in time?
Try what what cjswell posted. It looks interesting with more error handling by a mod of the \administration\infusions.php
Try what what cjswell posted. It looks interesting with more error handling by a mod of the \administration\infusions.php
Quote
cjsewell wrote:
Hi, I just put togethter a infuisions.php file that will tell us a bit more information about whats going wrong.
You can download it from here
Install that then post up what the message says.
Cheers
CJ
answered
Quote
muscapaul wrote:
I just fails at the infusion stage? Have you any other significant modifications/infusions on the problematic site?
It sure does. Non at all....
answered
Quote
cjsewell wrote:
Read the read me ;)
This is not an infusion, its the admin panel to infuse infusions.
Backup your current administrations/inusions.php
Extract and upload the one in the tar file.
See what the message is when you attempt to infuse the calender after that
CJ
Now I get it.... I hope...:D
BRB
answered
Quote
AdnanAhmed wrote:
@WEC_Admin - i asked him to do that ... and he did. defused it, and made sure the tables were dropped from phpmyadmin.
i just dont' understand why its failing on one of your site and not the other ... did u do any changes to the files on this server? any modification at all?
No. Not a single one...
answered
Using the new administrations/inusions.php, and trying to infuse, I once again got the message:
Column count doesn't match value count at row 1
Infusions went from red to green... installed...however still out order...
Column count doesn't match value count at row 1
Infusions went from red to green... installed...however still out order...
Edited by langkawi on 03-05-2006 00:03,
answered
I made a spelling mistake in my previous post. The file is
administration/infusions.php
NOT administrations/inusions.php
If you realised this and infusions.php is in the correct place, then this baffles me.
Where about on the page is the error displayed.
eg Above the infuse sitcom
Between the infuse section and current infusions.
on a blank page.
If you want I could take a look at your site, and try and infuse it myself.
administration/infusions.php
NOT administrations/inusions.php
If you realised this and infusions.php is in the correct place, then this baffles me.
Where about on the page is the error displayed.
eg Above the infuse sitcom
Between the infuse section and current infusions.
on a blank page.
If you want I could take a look at your site, and try and infuse it myself.
answered
Quote
cjsewell wrote:
I made a spelling mistake in my previous post. The file is
administration/infusions.php
NOT administrations/inusions.php
If you realised this and infusions.php is in the correct place, then this baffles me.
Where about on the page is the error displayed.
eg Above the infuse sitcom
Between the infuse section and current infusions.
on a blank page.
If you want I could take a look at your site, and try and infuse it myself.
No problem spelling ;)
Its not my homepage. It belongs to a frind. I have to ask him to let other be admins...
Look at this:
Maybe this gives you an idee? :)
answered
Ahhhhh, its when the Panel is being added not, when its infused.
You can scrap that file I gave you before its useless here, restore your backed up one.
I'll look into it further, and get back to you.
You can scrap that file I gave you before its useless here, restore your backed up one.
I'll look into it further, and get back to you.
answered
File scrapped
I just saw something strange(?)
The infusion is called calendar_panel
This is how phpmyadmin looks:
fusion_infusions
fusion_kalender
fusion_kalender_settings
fusion_messages
fusion_messages_options
fusion_new_users
See the difference?
c vs k
Does this mean anything?
I just saw something strange(?)
The infusion is called calendar_panel
This is how phpmyadmin looks:
fusion_infusions
fusion_kalender
fusion_kalender_settings
fusion_messages
fusion_messages_options
fusion_new_users
See the difference?
c vs k
Does this mean anything?
Edited by langkawi on 03-05-2006 09:19,
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
- Views 0 views
- Posts 55 posts
- Votes 0 votes
- Topic users 7 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions