Hi guys, so my friend asked me to take over his forum. It is hosted on media temple right now, i want to move his forum into xampp, so i can make changes locally for testing and such. i installed xampp on my computer and created a vanilla database. what are the next steps?
You have to import the existing online things (files and data) in your empty local web place. I don't know MediaTemple, but you must have a ftp account and a kind of phpMyAdmin. Download the files via ftp, and import the data with phpMyAdmin (if you don't know how to, try to search-engine a bit). If I can give you one piece of advice, follow your local changes with a versionning system. Good luck, and keep us informed!
ok so, dump file created, files transfered via ftp. However, when i try to import the the data via phpmyadmin, it says file too large. I tried to use bigdump but i wasnt sure how to use it. I got a server error when i tried. any easier methods? or keep fiddling with bigdump?
You just have to create several files containing correct sql instructions, then import them in the right order. I think all you have to check are the parenthesis or brackets. Don't break your file between one opening and one closing.
So i broke up the SQL file and imported it. But got an error at the last file at the very end. I didn't get to see what the error was before i closed it. So i dropped everything in the database and then imported via Dinoboff's method. Again, i get an error. This time i have it available.
ERROR 1064 <42000>: 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 '<br /> <b>Fatal error</b>: Maximum execution time of 60 seconds exceeded in <b>' at line 1
Waw, a big one. Maybe an export table by table, the biggest one would be IMHO the Comments one, try this one first. Anyway, if it's just for test purpose, maybe you don't need every bit of information. Maybe you just need some hundreds of comments. But I just realise that Vanilla makes a count for different things: number of posts in a discussion, by users, so it could end inconsistant...
i just tried to run Vanilla locally with everything except ShortStat and i get "Server error!"
even if the db is not complete, i should be able to see something. All i get is "Server error! The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script. Error 500"
I was able to access Vanilla setup page when i had the new install files. What i did was remove all those files and replace them with the files that are online. Now i am unable to access anything in the Vanilla folder
LUM_Shortstat is a table generated by the Shortstat extension. This extension integrates Shortstat with Vanilla. Shortstat tracks activity on your site. You probably don't need that table.
Try to see what you have at the end of C:\xampp\apache\logs\error.log I think there's no need to run the installer if you have all the files and the data of a running Vanilla. About the DB, maybe you just need to create the table, not the data contained in it. I don't know ShortStat but I guess it will create the missing table for you automaticly.
"Warning: include(/home/virtual/site448/fst/var/www/html/appg/database.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\Vanilla\appg\init_vanilla.php on line 18
Warning: include() [function.include]: Failed opening '/home/virtual/site448/fst/var/www/html/appg/database.php' for inclusion (include_path='.;\xampp\php\pear\') in C:\xampp\Vanilla\appg\init_vanilla.php on line 18"
etc. , etc.. It cannot find many files that init_vanilla.php requires.
Using the IfModule is probably not the best solution if you've got Friendly URLs installed as it will think everything's redirecting properly and generate SEO-friendly links. However that won't be the case because you don't have the rewrite module installed and so the RewriteRules are being ignored. Either disabled the Friendly URLs extension or install Apache's Mod_Rewrite.
As for the MySQL error, any number of things could be wrong. Incorrect username, incorrect host or incorrect password. Alternatively you may just not have permission to access that MySQL server. I would check in your CPanel and possibly consult your host's technical support.
well this is all from moving the forum online to my localhost. Almost everything is working perfectly online, but these problems arise trying to run vanilla locally.
so i removed the ifmodule, then uncommented out the rewrite module and that worked fine. Then i realized the MySQL server had the wrong username and password. So i fixed that. Now i am finally able to see the forum. However it only shows in a text only format.
I get errors: File does not exist: C:/xampp/htdocs/extensions File does not exist: C:/xampp/htdocs/themes script 'C:/xampp/htdocs/people.php' not found or unable to stat
etc...
where can i find the file to change where this points to? I looked in conf\settings.php but couldnt find it
also, when i try to log in, i get redirected to the default page, but it doesn't know that i just signed in.
I think you should change the Application Path setting to C:\xampp\htdocs if that is indeed where you installed Vanilla. Also you'll need to change the Extension Path to point to the extensions folder.
I installed Vanilla to xampp\Vanilla. And i pointed the appication and extension path to xampp\Vanilla in conf/settings.php . But it still looks for the extentions and themes in htdocs. Am i missing something?
also, do you know why it wont recognize that i'm signed in?
Surely Xampp won't run anything that's not inside the htdocs folder as Apache will view htdocs as the web root. I would have thought you would need to install Vanilla to htdocs/