I upgraded last night my server to mysql 5 and get the followingin my apache
error.log. This is done in admin.pl when you want to get the list of the
stories, here the results is simply there areno stories on the site.
I do not know if it is normal, so I jusr wanted to warn you.
-- hostinfo='Localhost via UNIX socket' -- Unknown column
'stories.primaryskid' in 'on clause' -- SELECT hits, stories.commentcount AS
stories.uid, stories.tid,\n\t\ttime, stories.in_trash, primaryskid,
\n\t\tIF(skins.skid IS NULL, '_none', skins.name) AS skinname FROM
stories, story_text LEFT JOIN skins ON skins.skid=stories.primaryskid WHERE
stories.stoid = story_text.stoid ORDER BY time DESC LIMIT 0, 40"
The syntax we were using for LEFT JOIN, in a number of cases in the
code, worked in MySQL 4.1 and before, but not in MySQL 5.0. I went
through the code last month and fixed a number of those up. Slash
is not guaranteed to work well with 5.0 yet, though we're working
on that (and expect compatibility within a month or two).
The particular issue you're seeing, however, was fixed in March of
You probably want to upgrade. If you're going to continue running
5.0, you probably want to upgrade all the way to the latest T_ tag.
Note that the latest INSTALL file has slightly more informative
instructions on how to upgrade from one version of CVS to another:
Scroll down to "Slash CVS".