URL to your eFiction: www.select.wwelibrary.org
Version of eFiction: 3.2
Have you bridged eFiction, if so with what?: Nope
Version of PHP: Not sure
Version of MySQL: Still not sure 😕
Have you searched for your problem: Yes
If so, what terms did you try: 3.2 Upgrade, blocks, MySQL error
State the nature of your problem: When I try to re-initialize my blocks I get the following error:
A fatal MySQL error was encountered.
Query: INSERT INTO fanfictionfanfiction_blocks(`block_name`, `block_title`, `block_status`, `block_file`, `block_variables`) VALUES('info', 'Site Information', '0', 'info/info.php', '');
Error: (1054) Unknown column 'block_name' in 'field list'
I had a ton of MySQL problems when I upgraded (something with block_name and authorinfo tables as well as most of the other ones) and when I check around the forums I deleted the lines suggested in other threads for solving those problems but somehow now I have this one. Any help getting this to go away would be greatly appreciated.
Do you have a test account for us? Yeah, Username: Test Password: Test not sure if you can even get to the point to login seeing as it won't let me log out right now either.
Why do you have to reinitialize any blocks?
When I went to the main page of my site the blocks were there but blank. I don't know why. So I went into my admin panel to see what was wrong and it says "Initialize" next to each thing in the blocks menu...when I hit initialize or submit I get that error.
Seems like you've probably deleted you blocks table somehow. Do you know have access to and know how to use phpMyAdmin?
I do have access to phpMyAdmin and from there I am pretty much in the dark as to what to do.
Click where it says "SQL" and enter the following in the box where it says "Run SQL Query" or something similiar.
CREATE TABLE `TABLEPREFIXfanfiction_blocks` (
`block_id` int(11) NOT NULL auto_increment,
`block_name` varchar(30) NOT NULL default '',
`block_title` varchar(150) NOT NULL default '',
`block_file` varchar(200) NOT NULL default '',
`block_status` tinyint(1) NOT NULL default '0',
`block_variables` text NOT NULL,
PRIMARY KEY (`block_id`),
KEY `block_name` (`block_name`)
) TYPE=MyISAM
Replace TABLEPREFIX with your table prefix.
I did that, and now *most* of the blocks work except the site info, random story, categories,login, and recent story...When I went into the options of those blocks I got the following error:
Warning: include(blocks/) [function.include]: failed to open stream: Success in sitepath on line 12
Warning: include(blocks/) [function.include]: failed to open stream: Success in sitepath on line 12
Warning: include() [function.include]: Failed opening 'blocks/' for inclusion (include_path='.:/usr/share/pear') in sitepath on line 12
You'll probably need to edit the blocks table in phpMyAdmin and add the file for those missing blocks. It'll follow the same pattern as the others.
blocks/categories/categories.php
etc.
Thank you so much for your help 😀
