Principally_Speaking Posted June 2, 2008 Posted June 2, 2008 (edited) For some reason, the demo data isn't loading when I install. I wind up with a blank database. No errors are reported when creating the database. Edited June 2, 2008 by SYSMAN_MK
SimpleSi Posted June 2, 2008 Posted June 2, 2008 I just tried installing the latest 1.5.3 package on my local machine and it installed the dummy content OK. Did you click on the install sample content button? (Its not in the linear flow of the install and can be missed if just clicking on next next etc ) regards Simon PS WHen I did click on it - it gave an warning about XML data but still seemed to work.
Principally_Speaking Posted June 2, 2008 Author Posted June 2, 2008 Yes, I tried install sample data and got the Joomla sample data and not the Edugeek sample data. I tried renaming the joomla.sql file which seems to contain the Edugeek sample data, then I got an XML error but still no content.
SimpleSi Posted June 2, 2008 Posted June 2, 2008 (edited) I'm not a home now so can't check what content actually got loaded - I'll check later on. Edited June 2, 2008 by SYSMAN_MK Removed request for thread to be split.
SimpleSi Posted June 2, 2008 Posted June 2, 2008 Its fine with my local eg153 install - content is edugeek stuff. Are you installing on a local test setup or a remote site? Any chance your FTP upload didn't quite go 100%. regards Simon
KecskeBak Posted June 2, 2008 Posted June 2, 2008 My local 153 install is fine as well. I'm using XAMPP on Windows XP Home. All the best, Dave
Principally_Speaking Posted June 2, 2008 Author Posted June 2, 2008 It's a remote site that I'm using for testing! I haven't rerun the FTP transfer to check, but everything appears to be present and I had no error messages on upload. I did rerun the installer and still encountered the same problem. I tried to import the SQL data from joomla.sql using PHPMyAdmin and got an error #1193 - Unknown system variable 'SQL_MODE' I'm going to wipe everything and start over. Any chance the download is incomplete? I downloaded a version on Thursday or Friday that was completely missing the Administrator directory!
SimpleSi Posted June 2, 2008 Posted June 2, 2008 Any chance the download is incomplete? equals that was completely missing the Administrator directory! where I come from :confused: regards Simon
Principally_Speaking Posted June 2, 2008 Author Posted June 2, 2008 Okay, sorry... I should have added that I did download another copy last night that had the administrator directory, etc., uploaded it, and still had the problem. In any event, I'm downloading another fresh copy, wiping the files, folders, and database, uploading a new copy, and running the installer again.
alonebfg Posted June 2, 2008 Posted June 2, 2008 you dont need to import the joomla.sql file it will do it for you when you install if you do you need to change the #_ to jos_ and then create the config file manualy.
Principally_Speaking Posted June 2, 2008 Author Posted June 2, 2008 Thanks for that clarification. To be clear, when installing should I click the button to install the sample data? That is to say, is the sample data the Joomla sample data or the Edugeek sample data?
Principally_Speaking Posted June 2, 2008 Author Posted June 2, 2008 Still no joy! I wiped the database, files and folders, redownloaded the installation package, and uploaded it. Clicking the install sample data button during installation works perfectly and gives me Joomla sample data. I tried populating mySQL with Edugeek data, first changing the table names from #__ to jos__. First, I got this error... MySQL said: #1193 - Unknown system variable 'SQL_MODE' So I removed that line. Now I get this error... MySQL said: #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=utf8 AUTO_INCREMENT=1' at line 50 So I'm wondering if this is a mySQL/PHPMyAdmin version issue. According to the joomla.sql file... -- phpMyAdmin SQL Dump -- version 2.11.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 28, 2008 at 09:57 PM -- Server version: 5.0.51 -- PHP Version: 5.2.5 My server reports... -- phpMyAdmin SQL Dump -- version 2.6.0-pl2 -- http://www.phpmyadmin.net -- -- Host: bahula.ca -- Generation Time: Jun 02, 2008 at 04:15 PM -- Server version: 4.0.26 -- PHP Version: 4.4.4
Principally_Speaking Posted June 2, 2008 Author Posted June 2, 2008 FWIW, after removing the DEFAULT CHARSET=utf8 throughout the joomla.sql file it worked properly. It appears that I'm up and running now.
alonebfg Posted June 3, 2008 Posted June 3, 2008 there is an install guide but as a quick guide you select language put in database crend ftp credent and then click next there is no need to install sample data ignor the warning as the sample data has been built into the install sql. FWIW, after removing the DEFAULT CHARSET=utf8 throughout the joomla.sql file it worked properly. It appears that I'm up and running now.
alonebfg Posted June 3, 2008 Posted June 3, 2008 Where can I find a link for 153? Thanks it can be found on the sticky i update the link saves space but there is an issue at the moment my webserver cought fire so it might not be there.
Principally_Speaking Posted June 6, 2008 Author Posted June 6, 2008 there is an install guide but as a quick guide you select language put in database crend ftp credent and then click next I did this 3, 4, maybe even 5 times. It did not work. I kept getting an empty database. Find a server running MySQL 4 and try to install. My guess is that you'll experience the same problem. Editing the install sql file as mentioned above fixed the problem for me.
alonebfg Posted June 8, 2008 Posted June 8, 2008 lol I have done this loads of time i dont seem to have the same issue. One thing that may cause this issue is some servers dont allow large uploads to the sql server via php its a security thing If you want i will post the sql file as while so that you can just import it if that helps
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now