Unknown column
Asked Modified Viewed 2,224 times
asked
hey
after upgrade one of my site, i now when i try to add, edit a panel, get this error:
Unknown column 'panel_display' in 'field list'
whats wrong ?
after upgrade one of my site, i now when i try to add, edit a panel, get this error:
Unknown column 'panel_display' in 'field list'
whats wrong ?
Falk
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 12 questions
Preview this in a custom page:
Code Download source
<?php
$result = dbquery("ALTER TABLE ".$db_prefix."panels ADD panel_display TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER panel_access");
echo "panel_display added";
?> answered
Hi,
I get am getting this error when adding a new panel:
Column count doesn't match value count at row 1
Any ideas as it has got me a bit stumped...
Cheers :|
I get am getting this error when adding a new panel:
Column count doesn't match value count at row 1
Any ideas as it has got me a bit stumped...
Cheers :|
Edited by Bear on 10-02-2006 06:09,
Falk
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 12 questions
Run this through a custom page, paste the result here
Code Download source
<?php
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}panels");
if (mysql_num_rows($result) > 0) {
echo "<table class='tbl-border'>\n<td colspan='2'><b>Panels Table Scheme</b></td>\n";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class='tbl1'>".$row[0]."</td><td class='tbl2'>".$row[1]."</td></tr>\n";
}
echo "</table>\n";
}
?> answered
Hi Nick,
Here is the results from previewing that custom page above:
NOTE: This is a different site to that other issue regarding the E_NOTICES.
I can manually add a panel to the table using phpmyadmin and then use the interface to shift that panel around etc but can't add any new panels via the Admin area. This particular site is running PHPFusion v6.00.300 so should I just upgrade to 304 and check it then?
Cheers B)
Here is the results from previewing that custom page above:
Code Download source
Panels Table Scheme
panel_id smallint(5) unsigned
panel_name varchar(100)
panel_filename varchar(100)
panel_content text
panel_side tinyint(1) unsigned
panel_order smallint(5) unsigned
panel_type varchar(20)
panel_access tinyint(3) unsigned
panel_display tinyint(1) unsigned
panel_status tinyint(1) unsigned
NOTE: This is a different site to that other issue regarding the E_NOTICES.
I can manually add a panel to the table using phpmyadmin and then use the interface to shift that panel around etc but can't add any new panels via the Admin area. This particular site is running PHPFusion v6.00.300 so should I just upgrade to 304 and check it then?
Cheers B)
Falk
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 12 questions
v303 yes? i think you need to reupload admin/panels.php
answered
Quote
Digitanium wrote:
v303 yes? i think you need to reupload admin/panels.php
The site shows the version as V6.00.300 although I "thought" that it was 303 when I loaded it.. Is there a definate way to tell what version is loaded or should I just reload the V304 upgrade over the top?
The problem is on a development site of mine so it doesn't really matter if I blow it away I suppose apart from the hours of uploads for infusions/themes/mods etc. I do know that I hadn't modded anthing in this area though.
Thanks again,
Bear B)
Falk
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 12 questions
Yeah you can.
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
- Views 0 views
- Posts 7 posts
- Votes 0 votes
- Topic users 3 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions