Warning: ..mysql.php on line 337 Joomla 1.5 RC4 night build

neotec · Post by **neotec** » 15 Jan 2008, 12:59

Hi Jan,

I've some error codes in "Phoca Guestbook - Items"
"
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/libraries/joomla/database/database/mysql.php on line 337

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/libraries/joomla/database/database/mysql.php on line 337

Warning: array_unshift(): The first argument should be an array in /www/htdocs/administrator/components/com_phocaguestbook/views/phocaguestbooks/view.ht ml.php on line 68

Warning: current(): Passed variable is not an array or object in /www/htdocs/libraries/joomla/html/html/select.php on line 68"

Joomla 1.5 RC4 night build

any ideas ?

Post by **Jan** » 15 Jan 2008, 15:09

See your database, if there are two phocaguestbook tables created...

Jan

neotec · Post by **neotec** » 15 Jan 2008, 22:40

Hallo Jan,

danke fÄ‚Åºr Deine schneller Antwort !
Hab gerade gelesen dass Du auch gut deutsch sprichst.

Das Problem ist behoben.
Mein Fehler war das '#__'

Ich habe die Tabelle einfach mit dem gleichen prÄ‚Â¤fix benannt wie bei der Installation und jetzt geht alles !

Vielen Dank !

Post by **Jan** » 15 Jan 2008, 22:48

Ger · Post by **Ger** » 23 Jan 2008, 01:31

Hello,

I've got the same error codes, but i've got no phocaguestbook in the database. I don't know why he is not writing in the database. What could I do.

Sites works fine see www.brassers.nl/brasnw

Thanks for the reply.

Ger

Post by **Jan** » 23 Jan 2008, 12:49

You must do it manually. Just go to e.g. PHPMyAdmin and add SQL command here. You find it in install.sql. You must change all strings
FROM:
#__
TO
your-prefix_ in this file and then copy it and paste it to SQL window in PHPMyAdmin and add submit...

Jan

phd · Post by **phd** » 23 Jan 2008, 16:46

Hi, after installation I receive the same error, but after modify the install.sql to my prefix it doens't work, the same error appears.
I look in all files with #__ and replaced it with my prefix, the same error. I try also to install EasySql but this installation failed also. And I can't activate the System-Legacy plugin ;-(
What can I do?

Thanks a lot
Philip

Post by **Jan** » 23 Jan 2008, 17:40

Please let me know the errors

phd · Post by **phd** » 23 Jan 2008, 18:01

Hi, now it works
I found the PHPMayAdmin, sorry for my disturbance

Philip

Ger · Post by **Ger** » 23 Jan 2008, 20:09

Hello,

Jan, thnx for the quick reply. I've found the file and I change the prefix, that's done.

But when I submit it in sql i've got an error message from sql

#1064 - You have an error in your SQL syntax near 'CHARACTER SET `utf8`' at line 22

I've got the following versions :
PHPMyadmin 2.5.6
MySQL 3.23.58

Thanks for the reply, Ger

Phoca Forum

Warning: ..mysql.php on line 337 Joomla 1.5 RC4 night build

Hi Jan,I

See your database, i

Hallo Jan,

Hello,I&

You must do it manua

Hi, after installati

Please let me know t

Hi, now it works

Hello,Ja