s9y-0.9.1

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
craig

s9y-0.9.1

Post by craig »

I upgraded one of my tow virtual sites to this. It was working fine. Then recently I upgraded to PHP-5.1.1 from PHP5.0.5

I don't know if the effect was immediate but now I get an error on my 2nd virtual site.

I don't know if this related but I'm also experiences loading loops when I visit some sites... it's happening as I type this...the firesfox indicator is indicating that the , in this cas, that this site has not completly loaded ! ?

the serendipty error listes on the web browser:
Query failed
SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email

, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= '1134861068' AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table 'wwt.serendipity_entries' doesn't exist

Please comment if you have any ideas
thank you
judebert
Regular
Posts: 2478
Joined: Sat Oct 15, 2005 6:57 am
Location: Orlando, FL
Contact:

Post by judebert »

I'm not sure what's going on, and we'll probably have to wait for Garvin to get back before we find out. But other posts in the forums have also found trouble with PHP 5.1.1.
craig

seems to be fixed

Post by craig »

I'm only running one of the web site at the moment... I'm making the rounds of where I left messages reporting this problem to say that I seem to have a fix.

Up to this point I thought hardware either worked or didn't. It appears my ethernet card was failing. I replace it with different ethernet card and now I don't have the web loading hangs I was getting. Now to change back to the httpd.conf that uses the virtual DocumentRoot assignments.

Unfortunately I totally zapped the the contents of that site...and will have to start it fresh. It was my test site so not much is lost
craig_s9y
Regular
Posts: 30
Joined: Wed Aug 24, 2005 12:57 am

Post by craig_s9y »

I'm back to runnin both web blogs with the virutal DocumentRoot settings
I reinstalled 0.9.1 back onto the blog site that it was previously running on and created a new database for this blog.

Eveything went smoothly, however I discoved that I can not lod the calander plugin....All the other plugins load execpt this one. I wanted to change the starting day of a week to Sunday.It's hangs trying to complet the loading of the page (much like I was experiencing across the board) with my previously installed networks card.

I don't know maybe I still have some element of the old problem.. I'm still watching for any piculiarities... the refresh on this web site is not quite right.... the bold bars at the tops of the windows don't fill out unless I move the scroll up and down. But this is the first time so far to note something that's still unusual with my overall system response

The primary blog is still running s9y 0.8.5. I think i've tested just about every feature with it and it is 100%.

So, I don't know, does the calander, use the database... if so then I suppose that the newly created supporting database is already corrupted or somehow php5.1.1 and s9y 0.9.1 are not in sync... ?

thank you
craig_s9y
Regular
Posts: 30
Joined: Wed Aug 24, 2005 12:57 am

Post by craig_s9y »

I apologise for all these follow up messages

I was just successful editing the calander plugin (from another machine on my network !)

I suppose this could mean their's still some glich on the machine running the blog server.

I don't think php5.1.1 is a problem or the problem
Post Reply