This is an error th...
 
Notifications
Clear all

This is an error that occurs with upgrade and new install

18 Posts
5 Users
0 Reactions
3,719 Views
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

Sorry I didn't use the template
b]URL to your eFiction:htt;://luckysevenentertainment.net/storys
Version of eFiction:3
Have you bridged eFiction, if so with what?:???
Version of PHP: can be found out from your host 4
Version of MySQL: can be found out from your host 4
Have you searched for your problem: (yes/no)yes
If so, what terms did you try:here
State the nature of your problem: Copy and paste any errors you are receiving.Fatal error: Cannot break/continue 1 level in /xxx/xxx/xxx/xxx/www/storys/includes/pagesetup.php on line 103

Do you have a test account for us?same as above


 
Posted : 29/03/2008 10:54 am
(@babaca)
Posts: 722
Member Moderator
 

When I go up a level I see this error:

A fatal MySQL error was encountered.
Query: SELECT * FROM fanfanfiction_blocks
Error: (1146) Table 'luckyseven4.fanfanfiction_blocks' doesn't exist

Where is your efiction site located?
http://luckysevenentertainment.net/storys

or here

http://luckysevenentertainment.net/storys

?


******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3

 
Posted : 29/03/2008 3:37 pm
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

The original was luckysevenentertainment.net. I created the subfolder storys for testing. I originally was trying to upgrade 1.1 to 3. Thanks for looking.


 
Posted : 01/04/2008 1:35 pm
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

Is there anyone that has had the error message? I have not been able to get this to work.


 
Posted : 04/04/2008 12:13 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

Which version of eFiction are you trying to upgrade to? 3.4, or 3.4.1?

Make sure you have the latest one to try.


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 04/04/2008 2:11 pm
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

I have tried them all...I get an error of some sort all the way. I even tried to do the sql manually but get syntax errors.

Error: (1146) Table 'luckyseven4.fanfiction_settings' doesn't exist tried to maunual upload and got the syntax error.


 
Posted : 06/04/2008 3:44 pm
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

After Dl the lastest version I now have this Warning: Invalid argument supplied for foreach() in /xx/xx/xx/xx/www/header.php on line 88


 
Posted : 06/04/2008 9:50 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

When you post an error or bug to this forum, you have to give the link of the exact page where the error happens. You must also tell us exactly what you did, and were doing when you got the error.

Put your 1.1 version back up and make sure that it works the way it used to. Then post there with the link to the working 1.1.

Don't do anything else yet, okay?


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 06/04/2008 11:13 pm
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

tried tons of errors. It seems that it is looking for the new files. sorry I screwed this up bad. the address is www.luckysevenentertainment.net.


 
Posted : 11/04/2008 1:00 am
(@itanshi)
Posts: 381
Reputable Member
 

I'd start over. (just my opinion, try at your own risk) If you have important data, back it up. This can be done via the phpmyadmin - export (If you choose this option, you will have a lot of extra data than you need. INSERT is what you need, the program install the tables which would be the CREATE parts etc) if not the website propper. Then drop all the tables in the phpmyadmin. Reinstall from scratch and add in everything automatically and then import the backup data in phpmyadmin (use the same prefix and sitekey). If there are any further complaints then its probably extra data in the backup from uninstalled modules or other features. Just cut those sections of the backup file into a new file (save as .sql) until it works, then add those missing parts on the site and then you may import the new file. Hopefully it'll work this time. Going to take some patience, I've done it like 4 times this week.

Hmm judging by the new errors, might want to try reinstalling the files too. Did you do anything to them?


I am rebuilding efiction! Join us on irc! #efiction at www.mibbit.com Instructions for irc πŸ˜€ Alpha released!

 
Posted : 11/04/2008 10:33 am
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

Ok I started from scrath, backed up the info in the database and now at keast I have no eroors, however I also have no stories or authors. I have tried to insert data in but I get sql errorrs. when you said to name the tables the same what did you mean? I really am confused. 😐 πŸ˜•

I did sucessfully upload some of the data but the biggest is the authors and stories. I seem to get #1136 - Column count doesn't match value count at row 1 Is there anyone that can help an old man?


 
Posted : 17/04/2008 5:52 pm
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

Hello again just was wonddering if anyone knows database.I have upgraded and I am trying to populate the databse from a backup. I have a 140 stories and about 200 membes but I can't seem to get the database to populate. Thanks.


 
Posted : 19/04/2008 1:29 pm
(@itanshi)
Posts: 381
Reputable Member
 

The error means you have a backup file that doesn't quite fit into the table you are entering it into. the same name means the table prefix. naturally they need to be the same so it enters the data into the right places.  You could actually import it piece by piece. The settings table is probably what's complaining as it enters data into maybe 30 columns and more if you added extensions or blocks. Make sure those line up correctly. Actually you'd also need to empty the tables in phpmyadmin before you import the data, but make sure the tables line up.

FYI The 'structure' is the shape of the table. the 'browse' is the population in a table. When you 'empty' you lose the population. The backup restores this population, but the shape needs to match.


I am rebuilding efiction! Join us on irc! #efiction at www.mibbit.com Instructions for irc πŸ˜€ Alpha released!

 
Posted : 19/04/2008 11:00 pm
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

Thanks for the reply itanshi...this is way over my head.I tried as you to dump the tables and repopulate but I got syntax errors. I guess I will try to see if I can't extract each story from the database. Thanks anyway.


 
Posted : 20/04/2008 1:38 am
(@buzltyr)
Posts: 11
Active Member
Topic starter
 

Is there actually a way to get the stories from the database? I can find the name etc but not the text. The version 1 I had the stories in the database.


 
Posted : 29/04/2008 9:00 pm
Page 1 / 2
Share: