Recent Topics
  1. b2evolution CMS Support Forums
  2. Archives
  3. Obsolete Forum Threads
  4. MySQL error! Help me..

MySQL error! Help me..

1 Jul 19, 2004 07:22    

i've successfully install b2evo v 0.9.0.10 in my localhost with XAMP servers kit. I can make a new categories, and all things to do.

But i cant view my blogs [all]
http://localhost/b2/blogs/index.php?blog=1

i'm just get this message

MySQL error!

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 ') AND ( ( post_status = 'private' AND post_author = 1 ) OR (Errno=1064)

Your query:
SELECT DISTINCT ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content, post_title, post_urltitle, post_url, post_category, post_autobr, post_flags, post_wordcount, post_comments, post_renderers, post_karma FROM (evo_posts INNER JOIN evo_postcats ON ID = postcat_post_ID) INNER JOIN evo_categories ON postcat_cat_ID = cat_ID WHERE 1 AND postcat_cat_ID IN () AND ( ( post_status = 'private' AND post_author = 1 ) OR post_status IN ('published','protected') ) AND post_issue_date <= '2004-07-19 12:21:23' ORDER BY post_issue_date LIMIT 5

please help me.. new install, not upgrade from any version!

Back to top

2 Jul 19, 2004 07:24

ApacheFriends XAMPP (basic package) version 1.4.5 (win32)

+ Apache 2.0.50
+ MySQL 4.0.20
+ PHP 5.0.0 + PHP 4.3.8 + PEAR
+ PHP-Switch win32 1.0 (by Apachefriends, use the "php-switch.bat")
+ mod_php 4.3.7
+ MiniPerl 5.8.3
+ SQLite 3.0.1
+ PHPMyAdmin 2.5.7 pl1
+ ADODB 4.21
+ Mercury Mail Transport System for Win32 and NetWare Systems v4.01a
+ FileZilla FTP Server 0.9.1
+ Webalizer 2.01-10
+ Zend Optimizer 2.5.3

Back to top

3 Jul 20, 2004 15:52

there is no one can help me about this??

Back to top

4 Jul 20, 2004 16:59

Somehow $cat is getting set, but is empty.

Is there anything weird that might be going on with the index file? Have you modded it at all? Try going to the standard stub_all.php instead of through the index file. Does that work?

Back to top

5 Jul 21, 2004 20:29

OMG i know the problem.. Cause i use php 5, when i switch to php 4 everything its ok.. :lol:

Sorry..

Now i'm trying to make a site again.. see ya

Back to top

6 Jul 23, 2004 01:35

Ah. Looks like we've got a bit of work to do if we're going to be forwards-compatible. Thanks for telling us what the problem was!

Back to top

8 Jul 24, 2004 18:09

Strange.. I'm running PHP5 also at home, but have not recognized any problems with the code yet.

OTOH I'm not very much into development the last days.

Back to top

9 Jul 26, 2004 21:08

i dont know why..

Cause when i switch to php4, all script in my localhost is normal

Back to top

10 Jul 26, 2004 21:41

blueyed wrote:

Strange.. I'm running PHP5 also at home, but have not recognized any problems with the code yet.

OTOH I'm not very much into development the last days.

I've upgraded the EDIHost server to php5 and am having no problems with it on any of the b2evo powered sites recently, some running 0.8.* and others 0.9.0.10 and .9

Back to top


Form is loading...