I think I've gotten my site finally upgraded from version 2 to 3.3.1 except for one part. Some how the modules table didn't created. I click on the modules link within the admin section and I get this...
A fatal MySQL error was encountered.
Query: SELECT * FROM fictionfanfiction_modules ORDER BY name
Error: (1146) Table 'allihave_fiction.fictionfanfiction_modules' doesn't exist
So I went to myphpadmin and sure enough, there isn't one there. I thought maybe I could find something in the install folders, like within the php coding and what not. If there is, I sure can't find it or figure it out. I was wondering if someone could help me as in give me some pointers on how to create the table manually.
Thanks!
CREATE TABLE `PREFIXfanfiction_modules` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default 'Test Module',
`version` varchar(10) NOT NULL default '1.0',
PRIMARY KEY (`id`),
KEY `name_version` (`name`,`version`)
)
Replace PREFIX with your table prefix.
Thank you so much!
Okay so I thought my problems and worries were out the door. But unfortunately they're not. I've just been handled a new batch of problems. These happened after I installed the modules table. The challenges I had before are showing up in myphpadmin, as are the series that had been with the previous version before I upgraded.
When I click on browse.php?type=series I get the following error...
A fatal MySQL error was encountered.
Query: SELECT chalid, title FROM fanfiction_challenges WHERE FIND_IN_SET(chalid, '') > 0
Error: (1146) Table 'allihave_fiction.fanfiction_challenges' doesn't exist
Which is completely wrong because the table should be allihave_fiction.fictionfanfiction_challenges if I'm understanding this all correctly, not allihave_fiction.fanfiction_challenges. So that is problem number 1.
-
My next problem is when I clicked on the challenges link from my home page, I received an error. So I searched the forums and found that I needed to correct the link to browse.php?type=challenges and so I did. But when you click the challenges link now, I get the following...
Error!We encountered an error. Please go back and try again.
I have no idea on how to fix that. I have tried changing the challenges link all kinds of ways and I've gotten everything from blank pages to mysql errors so I put it back.
-
Another problem I am having is when I go to Admin and then lick on Challenges. I get "You are not authorized to access that function." which I'm not understanding at all. When going to Admin then clicking on Modules, then the uninstall link for Challenges, I get the following...
Fatal error: Cannot redeclare categoryitems() (previously declared in /home/allihave/public_html/fiction/includes/corefunctions.php:26) in /home/allihave/public_html/fiction/includes/corefunctions.php on line 26
If I go back to Admin, click on Modules then Challenges I get the version but none of the challenges I see in the database over on myphpadmin. If I go to Admin, click on Modules then click on options I get "You are not authorized to access that function." as well as the following...
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main() [function.include]: Failed opening '../../header.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
--
I have attempted to try and figure out these problems as well as search through the forums. I am having no luck at all. I'd like to blame the time (it being 3am) and the fact that I am getting a wee bit sleepy as well as frustrated with my site. But any help/suggestions would be truly appreciated. And I thank you in advance!
At this point I think you're going to have to supply the information in the support request template. Give us the URL so we can poke around.
Here is the information. I didn't know if I should start another thread or just keep all the information in this one.
URL to your eFiction: http://fiction.allihave.net
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: nope
Version of PHP: 4.4.4
Version of MySQL: 4.1.22-standard
Have you searched for your problem: yes
If so, what terms did you try: challenges, series, etc
State the nature of your problem: I posted it before Tammy's reply but I will post it again.
When I click on browse.php?type=series I get the following error...
A fatal MySQL error was encountered.
Query: SELECT chalid, title FROM fanfiction_challenges WHERE FIND_IN_SET(chalid, '') > 0
Error: (1146) Table 'allihave_fiction.fanfiction_challenges' doesn't exist
Which is completely wrong because the table should be allihave_fiction.fictionfanfiction_challenges if I'm understanding this all correctly, not allihave_fiction.fanfiction_challenges. So that is problem number 1.
-
My next problem is when I clicked on the challenges link from my home page, I received an error. So I searched the forums and found that I needed to correct the link to browse.php?type=challenges and so I did. But when you click the challenges link now, I get the following...
Error!We encountered an error. Please go back and try again.
I have no idea on how to fix that. I have tried changing the challenges link all kinds of ways and I've gotten everything from blank pages to mysql errors so I put it back.
-
Another problem I am having is when I go to Admin and then lick on Challenges. I get "You are not authorized to access that function." which I'm not understanding at all. When going to Admin then clicking on Modules, then the uninstall link for Challenges, I get the following...
Fatal error: Cannot redeclare categoryitems() (previously declared in /home/allihave/public_html/fiction/includes/corefunctions.php:26) in /home/allihave/public_html/fiction/includes/corefunctions.php on line 26
If I go back to Admin, click on Modules then Challenges I get the version but none of the challenges I see in the database over on myphpadmin. If I go to Admin, click on Modules then click on options I get "You are not authorized to access that function." as well as the following...
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main() [function.include]: Failed opening '../../header.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Do you have a test account for us? nope sorry. i can create one though.
Okay for us to poke around you need to take it out of maintenance mode or supply a test account with admin level 4 access. Please also one problem per thread.
I went ahead and created one. I posted the errors here because they came up after I had created my table. But I went ahead and created a new thread. It can be found here https://efiction.org/forums/index.php?topic=5727.0
