Hello,
maybe somebody could be able to give me a hint?
I’ve followed the instructions to add new weblogs, made the new files, edited them and all seems to be fine. I came to the point where I changed the following line:
<?php weblog_entries($id,“newweblog”); ?>
where “newweblog” was “weblog” before, as it was my first one.
I get an “1064” MySQL error, that I don’t want to care for at the moment (I post it at the bottom of the message).
I’ve found out that this error does not occur, if I don’t change the line mentioned from “weblog” to “newweblog”. It just this line. All the other changes I’ ve made for the new weblogname, also those in the other new files don’t have a problem.
If I leave the line with “weblog”, I seem to have a new weblog, for which I can set preferences and so on. But I have the weblog entries of my original “weblog”- weblog. So here is my question: Where is pmachine supposed to put the entries for new weblogs? Shouldn’t there be an SQL table in my database (where “weblog” already exists, but not “newweblog”)? The new weblog “newweblog” seems to mix up with the first, the “weblog” weblog. I would like to solve the problem, but it seems, that I don’t understand the general way it has to be. The tutorial does not show any step to create a “real” place for the new “newweblog”. And as the new files (comments.php, trackback.php, pingback.php, more.php and archives.php) are just for special functions, there is only the “newweblog.php”- file, remaining, that could contain any further information. And the information I search for, seems to be the line with the weblog_entries. BUT WHERE ARE THEY?
So, very much talk for a beginner. But maybe somebody can help?
So, thank you in advance, at least for reading!
Here is the out put from “http://mymac/~xyzcologne/pmachinePro2.4.1/newweblog.php” (which I did not expect anybody to check this for me)
MySQL 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 ‘) order by sticky DESC, t_stamp desc’ at line 6
Query: select *, GREATEST(c_date, t_stamp) AS cw_date from pm_weblog where weblog = ‘elearninginmarketing’ and status = ‘open’ and preview != ‘1’ and t_stamp <= ‘1144246940’ and x_stamp >= ‘1144246940’ ) order by sticky DESC, t_stamp desc
