URL to your eFiction:
http://always-fanfic.net/eFiction/
Version of eFiction:
1.1 to 3.0.2
Have you bridged eFiction, if so with what?: NO
Version of PHP: 4.3.10
Version of MySQL: MySQL 4.0.22
Have you searched for your problem: (yes)
If so, what terms did you try:
blank index page, blocks dont exist, prefixes, blocks
installing tables
Have you looked at the FAQs:
Yes
State the nature of your problem: Copy and paste any errors you are receiving.
I've looked all over this board for like a day now cause at first I coudlnt register. I've come close to see others with my issues. As a matter of fact this url has exactly my problem. Thing is I dont know exactly how to fix it. I'm guessing it has to do with my blocks not being in phpmyadmin? I'm not good with mysql.
https://efiction.org/forums/index.php?topic=4134.0
But this is the error I get on the blank index page:
FATALERRORQuery: SELECT * FROM ff_fanfiction_blocks
Error: (1146) Table 'always_Alwaysfic.ff_fanfiction_blocks' doesn't exist
I tried reinstalling with the latest version and during the install when I tried to install the tables automatically? I get a blank, black page, I selected it and got this:
A fatal MySQL error was encountered.
Query: CREATE TABLE `ff_fanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) TYPE=MyISAM;
Error: (1050) Table 'ff_fanfiction_authorfields' already exists
I could go back and install tit manually but I honestly dont know how and I dont want to make an even more bigger mess of things.
here's what's in my phpmyadmin now
Browse: (0 Rows) ff_fanfiction_authorfields
Browse: (0 Rows) ff_fanfiction_authorinfo
Browse: (0 Rows) ff_fanfiction_authorprefs
Browse: (268 Rows) ff_fanfiction_authors
Browse: (26 Rows) ff_fanfiction_categories
Browse: (160 Rows) ff_fanfiction_characters
Browse: (0 Rows) ff_fanfiction_comments
Browse: (139 Rows) ff_fanfiction_favauth
Browse: (401 Rows) ff_fanfiction_favstor
Browse: (8 Rows) ff_fanfiction_genres
Browse: (1 Rows) ff_fanfiction_news
Browse: (3 Rows) ff_fanfiction_ratings
Browse: (1574 Rows) ff_fanfiction_reviews
Browse: (1 Rows) ff_fanfiction_settings
Browse: (1 Rows) ff_fanfiction_settings_old
Browse: (1856 Rows) ff_fanfiction_stories
Browse: (5 Rows) ff_fanfiction_warnings
Browse: (11 Rows) sl18_category
Browse: (1251 Rows) sl18_chapters
Browse: (0 Rows) sl18_news
Browse: (508 Rows) sl18_rate
Browse: (344 Rows) sl18_review
Browse: (618 Rows) sl18_stories
Browse: (22 Rows) sl18_subcategory
Browse: (114 Rows) sl18_users
(ignore the rows etc, I tried copying and pasting the tables that I had)
Any help would be greatly appreciated, hope I did this right.
edited to add, i found how to add tables but I dont know what to put in the fields section that is if the missing blocks table is the answer.
Use the tables.sql in the docs/ folder to create the table. Don't forget to add your tableprefix.
Enter this in the SQL query tab in phpmyadmin
CREATE TABLE `fanfiction_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;
Again...add your table prefix to fanfiction_blocks. Then go to the admin area of your site and initialize the blocks and turn on the ones you need to. Some of them may not initialize. If they don't...come back here with the list and I'll give you the SQL for that as well.
Ahh you guys are back..
Hi Tammy, I created the blocks table but now I'm getting this erorr message at the index page above.
A fatal MySQL error was encountered.
Query: SELECT * FROM ff_fanfiction_classes
Error: (1146) Table 'always_Alwaysfic.ff_fanfiction_classes' doesn't exist
Now I copied and paste the classes section from the docs/tables.sql folder but I got an error message.
#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 6
I also noticed that the blocks code you gaved me which worked was different from the one in the folder.
Cause I was comparing the tables that I currently have to some in the folder and I think I'm still missing a few. Like series, panels, pagelinks etc., oh boy.
Ahh I looked at the code and realized that the only differen was the ) TYPE=MyISAM; at the end. So I went and added that instead of the others for classes, messages etc and they got created. So I can now see my index pages but not all of it, but I'm making progress...
Bump. Is this resolved? If there's no reply in a week. This will thread will be marked closed.
Nah Tammy its not resolved but I moved to a new host and now I've got new problems lol. I'll post about it in a bit.
Okay but this specific problem is no longer relevant?
yeah its no longer relevant.
