phpwcms Support Forum

Hi I installed the 0.93 version with mySQL 3.23.55, get a few sql errors

Changed all 'JOIN' to 'LEFT JOIN' work.

The upgrade script failed to, altered the table manualy.



Save config get an error to, Removed the 'c' alias in saveConfig.

Then everything work great.

I'm getting this error when I click the "albums" link:

Error:
You have an error in your SQL syntax near 'ON (g.`f_id` = f.`f_id`) WHERE g.`aid`=0 ORDER BY g.`position`' at line 1

Executed query:
SELECT g.pid, g.f_id, g.aid, g.caption, g.position, f.f_hash, f.f_ext FROM `phpwcms_galerix_picture ...

Hey.

I have created a site for a friend of mine. It's the firs site i have made with phpWCMS. phpWCMS is an exellent tool to use. I am thinking about use it for my personal site.

Adriaticmarine is a norwegian site. So everything is in norwegian. But you can take a look at the design.

link: http ...

This problem was easy fixed on my site when i replaced this :
$guestbook['sql'] .= "guestbook_useragent='".md5($_SERVER['HTTP_USER_AGENT'])."'; ";

with this :

$guestbook['sql'] .= "guestbook_useragent='".md5($_SERVER['HTTP_USER_AGENT'])."' ";


in 'cnt18.article.inc.php'

Oliver Georgi wrote:can you send or show me a sample?

I have never heard that ending sql query with a semicolon is nor allowed.

Oliver

Take a look here:

http://no.php.net/manual/en/function.mysql-query.php

It's strange that the 22/6 version did not give any problem with
the ending semicolon.

Yes, and after removing the semicolon in the SQL string the insert work nice.
Maybe this is depend on php/mysql version?

My web server is running PHP 4.3.1, and
the database server running mySQL 3.23.55.


Rolf

Inserting new record i guestbook failed in my site, a little debugging
ended up with the following fix:

The SQL query for INSERT end with a semicolon, in cnt18.article.inc.php

This is not allowed for 'mysql_query' .

BTW, the frontend_init/sample.php generate output that make error after ...

Hi,
On a new site i'm working on i need smtp transport in the formmailer.
Is phpmailer implemented in the formmail content ?

phpWCMS Version is v1.1.-RC4 running on Suse 8.2.

ehoeven wrote: $_SERVER["DOCUMENT_ROOT"] = "D:\www\tuinenvijver.nl\www";

Try it this way:

$_SERVER["DOCUMENT_ROOT"] = "D:/www/tuinenvijver.nl/www";

The RC2 release do not work with postfix MTA. Look in /var/log/mail log for the error message.

I can do the Norwegian translation...

The new search form look very promising, but it also
return deleted pages.

This is not a new on but with rewrite engine enabled i can't get the color picker to popup.

My .htaccess file :
RewriteEngine on
RewriteRule ^(.*)\.html$ index.php?id=$1
RewriteRule ^index.html$ index.php

The box for hidden a menu item missing the word hide.
It now work opposite to the text. This is with english backend.

My server configuration can be found at http://www.eticoweb.it/phpinfo.php

from your phpinfo.php:
safe_mode On Off

Then you can go into trouble when det http server is
running as a user different from your account name.
I don't now if phpWCMS support that because it require some extra ...