Difficulties with n...
 
Notifications
Clear all

Difficulties with new 3.5.3 install, SQL errors

6 Posts
2 Users
0 Reactions
2,374 Views
 Dana
(@dana)
Posts: 11
Active Member
Topic starter
 

URL to your eFiction: www.kypandjaina.net
Version of eFiction: 3.5.3
Have you bridged eFiction, if so with what?: no
Version of PHP:
Version of MySQL: 5.5
Have you searched for your problem: yes
If so, what terms did you try: copy/paste of error
State the nature of your problem: see below
Do you have a test account for us? no

When I try to automatically install, I get the following:

A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS`settingsfanfiction_settings` ( `sitekey` varchar(50) NOT NULL default '1', `sitename` varchar(200) NOT NULL default 'Your Site', `slogan` varchar(200) NOT NULL default 'It''s a cool site!', `url` varchar(200) NOT NULL default ' http://www.yoursite.com', `siteemail` varchar(200) NOT NULL default 'you@yoursite.com', `tableprefix` varchar(50) NOT NULL default '', `skin` varchar(50) NOT NULL default 'default', `hiddenskins` varchar(255) default '', `language` varchar(10) NOT NULL default 'en', `submissionsoff` tinyint(1) NOT NULL default '0', `storiespath` varchar(20) NOT NULL default 'stories', `store` varchar(5) NOT NULL default 'files', `autovalidate` tinyint(1) NOT NULL default '0', `coauthallowed` int(1) NOT NULL default '0', `maxwords` int(11) NOT NULL default '0', `minwords` int(11) NOT NULL default '0', `imageupload` tinyint(1) NOT NULL default '0', `imageheight` int(11) NOT NULL default '200', `imagewidth` int(11) NOT NULL default '200', `roundrobins` tinyint(1) NOT NULL default '0', `allowseries` tinyint(4) NOT NULL default '2', `tinyMCE` tinyint(1) NOT NULL default '0', `allowed_tags` varchar(200) NOT NULL default '

              * ', `favorites` tinyint(1) NOT NULL default '0', `multiplecats` tinyint(1) NOT NULL default '0', `newscomments` tinyint(1) NOT NULL default '0', `logging` tinyint(1) NOT NULL default '0', `maintenance` tinyint(1) NOT NULL default '0', `debug` tinyint(1) NOT NULL default '0', `captcha` tinyint(1) NOT NULL default '0', `dateformat` varchar(20) NOT NULL default 'd/m/y', `timeformat` varchar(20) NOT NULL default '- h:i a', `recentdays` tinyint(2) NOT NULL default '7', `displaycolumns` tinyint(1) NOT NULL default '1', `itemsperpage` tinyint(2) NOT NULL default '25', `extendcats` tinyint(1) NOT NULL default '0', `displayindex` tinyint(1) NOT NULL default '0', `defaultsort` tinyint(1) NOT NULL default '0', `displayprofile` tinyint(1) NOT NULL default '0', `linkstyle` tinyint(1) NOT NULL default '0', `linkrange` tinyint(2) NOT NULL default '5', `reviewsallowed` tinyint(1) NOT NULL default '0', `ratings` tinyint(1) NOT NULL default '0', `anonreviews` tinyint(1) NOT NULL default '0', `revdelete` tinyint(1) NOT NULL default '0', `rateonly` tinyint(1) NOT NULL default '0', `pwdsetting` tinyint(1) NOT NULL default '0', `alertson` tinyint(1) NOT NULL default '0', `disablepopups` tinyint(1) NOT NULL default '0', `agestatement` tinyint(1) NOT NULL default '0', `words` text, `version` varchar(10) NOT NULL default '3.5.3', `smtp_host` varchar(200) default NULL, `smtp_username` varchar(50) default NULL, `smtp_password` varchar(50) default NULL, PRIMARY KEY (`sitekey`) ) TYPE=MyISAM;
                Error: ()

But when I try to manually install, I get this:

Error

SQL query:

--
-- Table structure for table `fanfiction_authorfields`
--
CREATE TABLE `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 ;

MySQL said: Documentation
#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 'TYPE=MyISAM' at line 15

My host has been of very little help in this. I couldn't find what version of PHP they've got installed and Support hasn't told me.


 
Posted : 26/05/2012 5:03 pm
 Dana
(@dana)
Posts: 11
Active Member
Topic starter
 

Okay, I figured this out by taking out the settings prefix. Now my problem is that I have this at the top of every page:

Warning: include(version.php) [function.include]: failed to open stream: No such file or directory in /home/kypjaina/public_html/install/languages/en.php on line 2

Warning: include(version.php) [function.include]: failed to open stream: No such file or directory in /home/kypjaina/public_html/install/languages/en.php on line 2

Warning: include() [function.include]: Failed opening 'version.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/kypjaina/public_html/install/languages/en.php on line 2

Now, I did roll back to a previous download of 3.5, thinking that might be part of the problem. Would upgrading to 3.5.3 after my install is done fix that?


 
Posted : 26/05/2012 7:54 pm
 Dana
(@dana)
Posts: 11
Active Member
Topic starter
 

NOW I can't install the tables, manually or automatically. I get the following either way:

A fatal MySQL error was encountered.
Query: CREATE TABLE `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: (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 'TYPE=MyISAM' at line 11

Is there anyone out there who can help me? Please? This has taken all day.


 
Posted : 26/05/2012 7:57 pm
 Dana
(@dana)
Posts: 11
Active Member
Topic starter
 

Honestly, I'm about ready to scream. I figured out that 5.5 didn't like the ) TYPE=MyISAM; and changed it to ) ENGINE=MyISAM DEFAULT CHARSET=latin1; and the rest of the install went off without a problem.

Except . . .

Now when I try to log in to my admin account, I get the following:

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83

Notice: Undefined index: link_key in /home/kypjaina/public_html/includes/pagesetup.php on line 83
A fatal MySQL error was encountered.
Query: SELECT nid, author, title, story, UNIX_TIMESTAMP(time) as date, comments FROM fanfiction_news ORDER BY time DESC LIMIT 1
Error: (1054) Unknown column 'comments' in 'field list'

Any idea how I can fix *this* mess? I'm willing to edit everything manually if I have to, I just don't know what it wants.


 
Posted : 26/05/2012 8:37 pm
 Dana
(@dana)
Posts: 11
Active Member
Topic starter
 

Now the error says

Query: SELECT nid, author, title, story, UNIX_TIMESTAMP(time) as date, comments FROM fanfiction_news ORDER BY time DESC LIMIT 1
Error: (1016) Can't open file: './kypjaina_fanfic/fanfiction_news.frm' (errno: 24)

I give up. I've never had so many errors with one PHP installation before. The authors will just have to deal with no co-authoring.


 
Posted : 26/05/2012 9:55 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

Often these warnings like 'undefined' are essentially meaningless (a lot happen when blocks are activated yet not in place on a given page) and they won't appear when debug is turned off. The other errors are problematic. It looks like your db install didn't go quite to plan. I would take a hard look at it in comparison to install.php and make sure all the fields and indexes are correct. Can't open file fanfiction_news.frm also refers to MySQL problems. I've never actually heard about it, but the web tells me a .frm "Contains the formatting information or structure data for a MySQL database." I would double check the type on all the tables as that was problematic.


 
Posted : 28/05/2012 2:50 am
Share: