MemHT Portal is a Free PHP CMS and Blog
It permit the creation and the management online of websites with few and easy steps.
It's completelly customizable, expandable and suitable for all needs.
Moderators: Moderators
Forum RSS feedReply
MemHT-Portal-3.8.0 - MySQL Errno: 1064
AuthorText
qvitko
Just arrived
Avatar

Posts: 7
Contributes: 0

Gender: _MALE_
Online: No
Date: 30/05/2008 14:26
MemHT-Portal-3.8.0 - MySQL Errno: 1064
#post7587
i installed the MemHT_Portal_3.8.0 and under blocks - Forum, Who is online and Example news show me this:
code
Database error
Errno: 2 (MySQL Errno: 1064)
File: /home/users/brijanderove/brijanderove.cz/web/mem/blocks/block_forum_main.php
Line: 45
Function: get_list
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 'SELECT COUNT(*) FROM memht_forum_posts WHERE id=p.id OR parent=
Query: SELECT p.id,p.lastchild,p.name,DATE_FORMAT(d.date,'
%d/%m/%Y %H:%i') as date,d.author,(SELECT COUNT(*) FROM memht_forum_posts WHERE id=p.id OR parent=p.id) AS pstnum FROM memht_forum_posts AS p JOIN memht_forum_forums AS f JOIN memht_forum_posts AS d ON p.forum=f.id AND p.lastchild=d.id WHERE f.auth_view<=3 AND f.auth_read<=3 ORDER BY p.lastchild DESC LIMIT 10
Note: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
i look on it whit firefox, but i look whit internet explorer or opera are the blocks empty - any idea to repair?

live web
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 5130
Contributes: 2473

Gender: _MALE_
Online: No
Date: 30/05/2008 15:00
Re: MemHT-Portal-3.8.0 - MySQL Errno: 1064
#post7588
What's your mysql version?

admin.php?page=memht&op=phpinfo
Delete Edit Quote
 
qvitko
Just arrived
Avatar

Posts: 7
Contributes: 0

Gender: _MALE_
Online: No
Date: 30/05/2008 15:24
Re: MemHT-Portal-3.8.0 - MySQL Errno: 1064
#post7590
4.0.18

report here
Edited: 30/05/2008 15:25
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 5130
Contributes: 2473

Gender: _MALE_
Online: No
Date: 30/05/2008 15:41
Re: MemHT-Portal-3.8.0 - MySQL Errno: 1064
#post7591
The problems is in your MySQL, it's too old and uncompatible with MySQL Subqueries.

Download MemHT Portal 3.7.0 and use thos files instead. If you have other problems i'm always here
Delete Edit Quote
 
Reply
Tags Cloud
Advertising
News Archive
Language
Help MemHT Portal
Navigator
Users Block
Hi Guest
IP: 38.103.63.59

Username
Password
New files
MemHT Wiki
Friends
MemHT Portal is a free software released under the GNU/GPL License by Miltenovik Manojlo