Fantastico install problem nuke 7.7

New Member Joined: Aug 04, 2005 Posts: 6

can anyone help please. I upgraded to 7.7 via fantasico and started having problems. i reading your posts and stuff and tried the patch. i got massage saying php not accesable at this time. I attempted to do the restore back up function on fantastico and deleted public.html folder, extracted backup, then i deleted our sql thing but cant upload backup.sql, so i then went back to fantastico to try and delete 7.7 and reinstall and it wont let me do anything now. i can give our ptf pass and pay if required. im in big trouble! i made back from admin panel and also forum admin backups of structure and data.
Can anyone help me please im a total novice. thank you.

Posted: Thu Aug 04, 2005 7:07 am

The first thing to do is re-instate the public_html folder.

The re-install failed because when Fatnastico installs a script, it leaves behind a text file in the directory root. Fantastico refers to this file if you try to upgrade the script via Fantastico or remove the script.

It seems you have deleted the whole thing manually and not with Fantastico, so fantastico thinks it is still installed.

If you have nothing in your web space, perhaps your hosting company can reset your account or the easiest option is to install nuke manually.

My personal opinion is that you get your hosting account reset and install nuke manually - use version 7.6 from this site. Do not use 7.7 or 7.8

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

And, to supplement what Guardian has said, it also installs a folder called .fantasticodata in your home folder root. Since the folder begins witha ., your ftp client may not be set up to display it as it is hidden. You will need to tell your ftp client to display the hidden files by adding the -a flag to the file mask. Once you get rid of all these files you should then be able to reinstall.

Posted: Thu Aug 04, 2005 7:18 am

Yes, I had forgotten that folder gets created Sad

Posted: Thu Aug 04, 2005 7:49 am

wow, ok thanks guys, well i guess i shouldnt have attempted anything like this. ive contacted our support to see if they can just re install the backup that fantastico did! I found out how to import the backup.sql but it timed out sigh! why is nothing straight forward? or am I just a dummy? lol dont answer plz.
Thanks again guys. Smile

Posted: Fri Aug 05, 2005 2:00 am

Well for some reason or another our support hasnt got back to us and i was wondering if you can tell me how to import the backup.sql into myphpadmin. it seems to time out because it only accepts 50.000k and our file is 5 meg. IS there an easy answer to remedy this or is it beyond a newbie? i looked at FAQ and dont understand what its telling me to do?if i install the 7.6 i will still have this problem of importing the backup!

Posted: Fri Aug 05, 2005 2:41 am

You will need to break the sql file down.
As you look at the file with a text editor, you can see where the tables themselves are created with code such as;

Code:

-- 


-- Table structure for table `nuke_blocks`


-- 





CREATE TABLE `nuke_blocks` (


  `bid` int(10) NOT NULL auto_increment,


  `bkey` varchar(15) NOT NULL default '',


  `title` varchar(60) NOT NULL default '',


  `content` text NOT NULL,


  `url` varchar(200) NOT NULL default '',


  `bposition` char(1) NOT NULL default '',


  `weight` int(10) NOT NULL default '1',


  `active` int(1) NOT NULL default '1',


  `refresh` int(10) NOT NULL default '0',


  `time` varchar(14) NOT NULL default '0',


  `blanguage` varchar(30) NOT NULL default '',


  `blockfile` varchar(255) NOT NULL default '',


  `view` int(1) NOT NULL default '0',


  `expire` varchar(14) NOT NULL default '0',


  `action` char(1) NOT NULL default '',


  `subscription` int(1) NOT NULL default '0',


  PRIMARY KEY  (`bid`),


  KEY `bid` (`bid`),


  KEY `title` (`title`)


) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=120 ;





--

After this, you should see where the data itself is 'inserted' into table;

Code:

INSERT INTO `nuke_blocks` (`bid`, `bkey`, `title`, `content`, `url`, `bposition`, `weight`, `active`, `refresh`, `time`, `blanguage`, `blockfile`, `view`, `expire`, `action`, `subscription`) VALUES (54, '', 'Visit Us Again', '', '', 'l', 1, 1, 3600, '', '', 'block-Visit_Us_Again.php', 0, '0', '', 0);


INSERT INTO `nuke_blocks` (`bid`, `bkey`, `title`, `content`, `url`, `bposition`, `weight`, `active`, `refresh`, `time`, `blanguage`, `blockfile`, `view`, `expire`, `action`, `subscription`) VALUES (88, '', 'Newest Links', '', '', 'r', 11, 1, 0, '', '', 'block-NSN_Web_Links_Newest.php', 0, '0', 'd', 0);

If you break the file down into more manageable chunks this will help you.
Try to keep 'inserts' with their corresponding table. To prevent you getting lost, I find when breaking a sql up that naming them sql1, sql2 etc helps as some of the inserts can be huge.

If you have cPanel', click on MySQL database -> phpMyAdmin
Select you nuke database from the drop down list.
Select the SQL tab then navigate to your files and upload in sequence making sure each upload has completed before moving on to the next file.

Posted: Fri Aug 05, 2005 2:53 am

so if i break the file down to say 10 chunks, wont the 2nd import overwrite the first? or will it just add the data?

Posted: Fri Aug 05, 2005 3:42 am

No, you are essentially splitting the one 'master' file into many smaller seperate files.
As each file will only have specific tables and data for those tables it will not over write the previously uploaded file.
The easiset way is to;
open a back-up copy of the master sql file in wordpad
open another 'blank document in wordpad
CUT a section from 'master' and paste in 'blank'
save blank sql1
open new blank
repeat process but dont forget to increment the sql file number sequence as you go

Once you have your 10 files, you import sql1, then import sql2 etc

The reason I suggest you CUT and paste rather than COPY and paste is that when you go back to your backed-up master sql, you will have no doubts about what data you have already done.

I know this is a pain to do and you probably dont need more than 2 or 3 sql files but in this instance, more is better as phpmyadmin will load the data much more quickly and reduce potential server load problems/timeouts etc.

Posted: Fri Aug 05, 2005 5:23 am

ok, thank you, do i need to dump the data first, theres 23 tables in there already, probably from a failed attemps, there should be 101 tables!
or should i create a new one then rename it if it has worked? sorry but im really struggling with this!
and once all parts have been imported, is there anythhing i have to do to initalise it?

Posted: Fri Aug 05, 2005 6:59 am

If this is a new website, that is to say, their are no news articles or forum posts, then I would recommend wiping the lot and doing a fresh install.

If this is an established site, then create a new back-up sql file. Dont forget, when splitting the sql file, use a copy of the original just in case your PC crashes half way through or some other 'Murhpys Law' gets a grip.

Posted: Fri Aug 05, 2005 7:17 am

I did it I did it omg Thank you for ur help, it worked like u said. its back up now wicked. thank you very much Wink

i can sleep again!

Posted: Fri Aug 05, 2005 8:20 am

No problem, glad we could help you.