URL to your eFiction: http://www.netraptor.org/fanfiction
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.7
Version of MySQL: 5.0.27-standard
Have you searched for your problem: yes
If so, what terms did you try: menu array, menu error, menu block not displaying
State the nature of your problem:
The menu block displays only "array" for each item. I've gone in and activated the various menu items and it didn't affect the problem. I can turn the block on and off, but not affect the menu items themselves.
I suspect part of the problem may have been the install. I was upgrading from 2.x to 3.3.1, and everything went fine until I hit the "install tables" step. It did not want to install over the old ones. So I skipped that step and went on, but now the menu won't display properly. What should I do? I'm not well-versed in MySQL, but I can follow directions.
Do you have a test account for us? I can make one if you need it.
You can't skip a step. Restore your backup and try again. You shouldn't be installing over an old archive either. You should be using the upgrade script to upgrade.
Okay. I deleted all the old files off the server and uploaded all the new ones. I ran it through a clean install and gave the database tables a different header. It installed all of them okay.
Then I went and deleted all the new tables and started running install/upgrade20.php with the idea that it would convert all the old tables. It converted the settings table all right, but on step 2 I get this:
Warning: main(../naughtywords.php) [function.main]: failed to open stream: No such file or directory in /home/netrap2/public_html/fanfiction/install/upgrade20.php on line 1021
Warning: main() [function.include]: Failed opening '../naughtywords.php' for inclusion (include_path='.:/usr/lib/php') in /home/netrap2/public_html/fanfiction/install/upgrade20.php on line 1021
Warning: implode() [function.implode]: Bad arguments. in /home/netrap2/public_html/fanfiction/install/upgrade20.php on line 1047
A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_settings( `sitekey`, `sitename`, `slogan`, `url`, `siteemail`, `tableprefix`, `skin`, `language`, `submissionsoff`, `storiespath`, `store`, `autovalidate`, `maxwords`, `minwords`, `imageupload`, `imageheight`, `imagewidth`, `roundrobins`, `tinyMCE`, `allowed_tags`, `favorites`, `multiplecats`, `newscomments`, `recentdays`, `displaycolumns`, `itemsperpage`, `displayindex`, `defaultsort`, `reviewsallowed`, `ratings`, `anonreviews`, `revdelete`, `rateonly`, `pwdsetting`, `alertson`, `disablepopups`, `agestatement`, `words`, `smtp_host`, `smtp_username`, `smtp_password`) VALUES( 'GpxkjG9nbm', '', '', '', '', '', '', '', , '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '');
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, ' at line 10
What do I do?
Restore your site to 2.0.7. ALL your files and your database. Then re-run the update NOT the install.
Okay, I rolled back the database, and re-uploaded the 2.0.7 files. Then I uploaded the 3.3.1 files over them and started running upgrade20.
On step 2, when I try to set a sitekey, I get this:
A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_settings( `sitekey`, `sitename`, `slogan`, `url`, `siteemail`, `tableprefix`, `skin`, `language`, `submissionsoff`, `storiespath`, `store`, `autovalidate`, `maxwords`, `minwords`, `imageupload`, `imageheight`, `imagewidth`, `roundrobins`, `tinyMCE`, `allowed_tags`, `favorites`, `multiplecats`, `newscomments`, `recentdays`, `displaycolumns`, `itemsperpage`, `displayindex`, `defaultsort`, `reviewsallowed`, `ratings`, `anonreviews`, `revdelete`, `rateonly`, `pwdsetting`, `alertson`, `disablepopups`, `agestatement`, `words`, `smtp_host`, `smtp_username`, `smtp_password`) VALUES( 'HbZuZDwcmP', '', '', '', '', '', '', '', , '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '');
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, ' at line 10
I have a backup of my config.php sitting on my desktop, but I hadn't backed it up until after I had uploaded 3.3.1 the first time. Is there any other way of finding my old sitekey, if the old script used one? I assume it'd be in the database somewhere.
The problem is the config. You need your 2.0.7 config to upgrade.
I got my friendly system administrator to fix it for me. He went through the above steps and cleaned up the database so it works now.
Thanks for your help, Tammy. I know that this is an unforgiving job.
