English > Development
PK's MovieDB dynamic website template
blue334:
You shouldn't delete fields from the database, it just adds more trouble. You may not need that data, but other files assume it is there at least as a blank value. It really doesn't matter if those fields are in the database, and stuff you don't want displayed you just comment out in the html files (.tpl files). But don't worry about that now, try getting your page up first.
Next, forget about exporting csv, it is not relevant to this. What you are exporting is sql script files with a .sql extension. If you haven't already you must copy the sql.ptm file to the ..\Personal Video Database\Plugins\Templates directory. That will make it appear as an option in the export dialog pulldown menu. Before exporting, you must make a subdirectory named "images" in the folder where you plan on saving the sql file. If you don't images won't go anywhere probably.
NB! After you have successfully created a file with .sql extension this goes into the database the same way the fields.sql file does. But in this case the file will be much bigger, so it will not be practical/possible to paste its content in the sql query area in phpmyadmin. Instead you should go to the IMPORT tab, where there is an option to select the file from your hd and run it directly.
The database connection problem you experience is due to wrong credentials or other info in mdb_config.inc
Since you're with byethost, it should look somewhat similar to this:
$this->config['mysql']['server'] = "sql207.byethost9.com";
$this->config['mysql']['username'] = "b9_2508518";
$this->config['mysql']['password'] = "mypass";
$this->config['mysql']['database'] = "b9_2508518_movies";
$this->config['mysql']['table'] = "movies";
Since you deleted fields in the database you must delete/drop it completely and run the fields.sql query again.
JedMeister:
--- Quote from: blue334 on October 25, 2008, 04:46:34 pm ---New domain/link where these are implemented: http://www.mymoviecollection.co.cc/
EDIT: if that link doesn't work properly try: http://blue334.byethost9.com
--- End quote ---
bottom link appears to be broken, currently redirecting to here: http://php0h.com/hosting-blog6/index.php with the message "YOU ARE VIEWING THE OLD WEBSITE PLEASE WAIT WHILE YOU ARE REDIRECTED". Not sure what that's about?!?
blue334:
Every free host has its nags - they need one way or another to make a revenue. I don't yet know how much of an issue this will be, but both my domains at byethost have had downtime of about 24h during which they redirect to ads. It is basically the same as the aforementioned blocked words at awardspace, where you get redirected to their front page (where they sell commercial hosting packages).
If one wants free hosting, its only a matter of choosing the lesser evil. I don't want forced ads on my site, and I didn't much like the awardspace thing with blocked words. If byethost is still the best choice remains to be seen, depends on the frequency of these programmed downtimes.
ruffa:
--- Quote from: blue334 on October 27, 2008, 10:46:21 pm ---Next, forget about exporting csv, it is not relevant to this. What you are exporting is sql script files with a .sql extension. If you haven't already you must copy the sql.ptm file to the ..\Personal Video Database\Plugins\Templates directory. DONE THIS OK That will make it appear as an option in the export dialog pulldown menu. Before exporting, you must make a subdirectory named "images" in the folder where you plan on saving the sql file DONE THIS AND I NOW SEE THE IMAGES ARE IN THERE. If you don't images won't go anywhere probably.
NB! After you have successfully created a file with .sql extension this goes into the database the same way the fields.sql file does DONE. But in this case the file will be much bigger, so it will not be practical/possible to paste its content in the sql query area in phpmyadmin. Instead you should go to the IMPORT tab, where there is an option to select the file from your hd and run it directly.
The database connection problem you experience is due to wrong credentials or other info in mdb_config.inc
Since you're with byethost, it should look somewhat similar to this:
$this->config['mysql']['server'] = "sql207.byethost9.com";
$this->config['mysql']['username'] = "b9_2508518";
$this->config['mysql']['password'] = "mypass";
$this->config['mysql']['database'] = "b9_2508518_movies";
$this->config['mysql']['table'] = "movies";
Since you deleted fields in the database you must delete/drop it completely and run the fields.sql query again.
--- End quote ---
Thanks for your help, i will redo the sql query and redo the database and redo the mdb config file, i think it's this that might be causing problems, u know the info u gave as an example of what it should look like, is this the only thing i should be changing? i altered a few more things on that file.
But even if the mdb config file was wrong, shoulkdn;t i have seen somehting when i tried to access the index.php file? i will redo it and see how i go this time.
Thanks again for all this help
ruffa:
I got the config file sorted now, i had the wrong password so i can now see the index.php ok. I made the new database in mysql etc.
but the problem i now have is when i try to import the .sql file it gives an error, it says 'Duplicate' i should have copied it for u to see but it highlighted the field YEAR and mentioned a duplicate in the database which gave an error. Any ideas what might be causing this?
I did change the way my pc shows the date, althought i only had the option to change the 'short date' as it says in windows options.
In PVD i actually do the dates liked: 21st Oct.2008 or 21/10/08 it changes.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version