forum.coppermine-gallery.net
No Support => Modifications/Add-Ons/Hacks => Mods: Bridging/Integration => Topic started by: Ludo on November 14, 2008, 12:32:09 pm
-
I started using Advanced Guestbook in my gallery a few months ago, thanks to this post (http://forum.coppermine-gallery.net/index.php?topic=10401.msg47119#msg47119) from TranzNDance, but soon I got unsatisfied with that raw integration with my CPG theme.
So, I modified guestbook core and template files to achieve a full visual integration (actual CPG theme applies to guestbook too, without specifying styles in guestbook admin panel), and an easier installation (no more need to manually create an integration file, enter DB settings etc.): actually, only admin panel runs still "stand-alone" (but opening in a separate window).
Tested with all default themes plus Connections and Greenflower
Demo: http://vanrokken.altervista.org/guestbook.php?theme=paesaggi
Installation:
- Extract attached archive to your CPG root directory
- Give write permissions (at least 775) to these directories:
- /guestbook/public
- /guestbook/tmp
- Run /guestbook/install.php in your browser and follow configuration instructions
- Open /lang/your_language.php and add this code at the end of file (before ?> ):
// ------------------------------------------------------------------------- //
// File guestbook.php
// ------------------------------------------------------------------------- //
if (defined('GUESTBOOK_PHP')) {
$lang_guestbook_php = array(
'guestbook' => 'Guestbook', // "Guestbook" in your language
'contact' => 'Contact us', // "Contact us" in your language
);
}- Now you can access guestbook from /guestbook.php (i.e. http://www.yourcpg.tld/guestbook.php) and admin panel - if logged in as Gallery admin - from the link on right top corner of guestbook area.
- Either custom link option in CPG configuration or mod suggested by calvinite (http://forum.coppermine-gallery.net/index.php/topic,55796.msg272648.html#msg272648) are good ways to place a link in the Gallery submenu ;)
- Since v. 1.0.3, you can have your guestbook act like a contact form, by placing in your sys or sub menu a "Contact us" link to
/guestbook.php?file=addentry&private=1
"Private message" flag in the "add entry" page will be automatically selected, so that message sent by user will appear only in admin panel "Private messages" section and in your mailbox (if private messages notification by email is enabled). A convenient header is displayed on top of the form (English and Italian only, other languages need adapting translation).
Upgrade: extract attached archive to your CPG root directory, replacing existing (old version) files
Changelog:
- 1.0.4 (11/5/2010)
- fixed bug in opening full size images attached to messages (thanks to Forty2)
- fixed admin panel footer
- 1.0.3 (27/5/2009)
- added check for "Private message" flag automatic selection (so Guestbook can act like a contact form)
- 1.0.2 (27/3/2009)
- fixed credits text in admin footer
- now guestbook language follows selection (or default one) in Coppermine
- fixed a bug with admin login (thanks to calvinite)
- 1.0.1 (26/3/2009)
- fixed a typo in readme file (thanks to calvinite)
- guestbook code updated to v. 2.4.4
- 1.0.0 (14/11/2008)
Feel free to post support requests, comments and suggestions in this thread :) :-[
-
Thanks for your contribution. I split it from the thread that you replied to initially (http://forum.coppermine-gallery.net/index.php/topic,55796.0.html), as your mod deserves a thread of it's own imo. I renamed this thread as well.
Regards
Joachim
-
Thanks for your contribution. I split it from the thread that you replied to initially (http://forum.coppermine-gallery.net/index.php/topic,55796.0.html), as your mod deserves a thread of it's own imo.
Thank you, I'm going to update support link in the readme file included in the archive.
I renamed this thread as well.
IMHO this new title doesn't match exactly with the mod, which doesn't simply apply Coppermine themes to stand-alone guestbook, but accomplishes a full integration of Advanced Guestbook in Coppermine (except for admin panel): can I rename it to "Advanced Guestbook integrated with Coppermine"? :)
-
Renamed as you suggested.
-
Thanks a lot, Joachim! ;)
-
I have installed per instruction, but upon entering the admin no matter what I click on it keeps repeating me for login name and password. So I cannot setup the admin??????
-
Did you enter guestbook admin ID and password chosen during guestbook installation, when prompted to?
-
Did you enter admin ID and password chosen during installation, when prompted to?
Yes I did.
-
Do you get a warning of invalid username/password? If not, try cleaning your browser's cache
-
Do you get a warning of invalid username/password? If not, try cleaning your browser's cache
installation is done succesfully, and no warning at all. Cleared cache, removed the tables and reinstalled, but same thing. If I click for instance general settings, i get the login screen again. It accepts my name and pass, since when I use another it says invalid username...
-
I see the problem already, my database uses a separate prefix like iqpq_ while the install creates like guestbook_auth
I can change the table into iqpq_guestbook_auth but then I get other error like 1146 Table 'guestbook_config' doesn't exist. So I gather I have to add the prefix in the program, where can I best do this?
-
Guestbook tables prefix shall be different than CPG one, there's no bug.
Mouse over the links to guestbook admin sections and check if the session number in the link matches with the one in guestbook_auth table.
Maybe your PHP installation doesn't support sessions?
-
Guestbook tables prefix shall be different than CPG one, there's no bug.
Mouse over the links to guestbook admin sections and check if the session number in the link matches with the one in guestbook_auth table.
Maybe your PHP installation doesn't support sessions?
I did a check :
http://www.fotofantastic.nl/guestbook/admin.php?action=settings&panel=general&session=749182e8b8f99b5ff29bbc654f23662b&uid=1
The session is the same as in the database so i guess the session is not supported.
Here is a list from coppermine
VERSION INFO :
------------------
PHP version: 5.2.6 - OK
------------------
mySQL version: 5.0.51a
------------------
Coppermine version: 1.4.19(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support: 1
JIS-mapped Japanese Font Support:
==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 1
Active Links 3
Client API version 5.0.51a
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/mysql/include
MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | system,exec,shell_exec,passthru,proc_open,proc_get_status,proc_nice,proc_terminate,dl,popen,pcntl_exec | system,exec,shell_exec,passthru,proc_open,proc_get_status,proc_nice,proc_terminate,dl,popen,pcntl_exec
file_uploads | On | On
include_path | .:/usr/local/lib/php | .:/usr/local/lib/php
open_basedir | /home/deb11675/:/tmp:/usr/local/lib/php/ | no value
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 8M | 8M
post_max_size | 8M | 8M
==========================
Page generated in 0.108 seconds - 19 queries in 0.022 seconds - Album set : ; Meta set: ;
-
Well, I've just discovered that guestbook sessions management doesn't relay on PHP sessions :-[ ???
Apart from admin section, does your guestbook work?
Are all guestbook files stored in /guestbook/ directory under your CPG root?
-
Well, I've just discovered that guestbook sessions management doesn't relay on PHP sessions :-[ ???
Apart from admin section, does your guestbook work?
Are all guestbook files stored in /guestbook/ directory under your CPG root?
Yes, the guestbook works fine, except from the admin section, so i cant configure it the way i would like to.
And again yes ;), the guestbook directory is placed in the cpg root. And cpg is in my webserver root, dont know if that makes a difference.
Cath
-
Sorry, but I really can't figure out the bug...I've just reinstalled guestbook from attached file and admin section works perfectly too!
Consider applying admin settings directly via database... 8)
P.S. Fixed a bug with guestbook admin email, now it is picked from CPG config table
-
Hello, i've just installed w/o any problem this mod, seems to be cool ...
except a captcha issue, ( picture doesnt appear).
http://rx-photo.info/guestbook/
http://rx-photo.info/guestbook/image.php?id=5ec0848e7750c83f60ac93ddff2de805
I try 2 browsers, same pb, and i try direct link from others installations, it works fine. Is this a right pb, an hosting pb ?
Ty
-
Cause is probably this notice:
Notice: Undefined index: gallery_admin_email in /web/rxphoto/www/guestbook/admin/config.inc.php on line 88
Either get the notice fixed (probably related to the bug mentioned above) or disable display of errors.
-
http://rx-photo.info/guestbook/
Not a valid url...
I try 2 browsers, same pb, and i try direct link from others installations, it works fine. Is this a right pb, an hosting pb ?
It looks like a "common" captcha issue: if you have GD2 libraries with Freetype support captcha will work, otherwise not. You can disable captcha by changing
define('USE_CAPTCHA', true);to
define('USE_CAPTCHA', false);in /guestbook/admin/config.inc.php
-
hoops sorry, was : http://rx-photo.info/guestbook.php?file=addentry
I think all is ok :
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.1.7
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
seems not ?
-
Yes, it seems.
But it happens to experience captcha issues even with GD2 installed and properly configurated, as you can see in captcha mod and plugin threads...
Do you have captcha mod or plugin installed and working?
-
Sorry, but I really can't figure out the bug...I've just reinstalled guestbook from attached file and admin section works perfectly too!
Consider applying admin settings directly via database... 8)
P.S. Fixed a bug with guestbook admin email, now it is picked from CPG config table
I find with debug two errors:
* Notice line 35: Undefined variable: lang_guestbook_php
* Notice line 37: Undefined variable: lang_guestbook_php
Maybe that is the cause of my problem, how to solve these?
-
They are just notices of lacking (optional) variable declaration, not errors.
But...oops, I forgot to include language files edits in the installations instructions: :-[ now they are in place in the first post.
For your convenience I write them here too : open lang/your_lang.php and add this code at the end of the file (just before ?> ):
// ------------------------------------------------------------------------- //
// File guestbook.php
// ------------------------------------------------------------------------- //
$lang_guestbook_php = array(
'title' => 'Guestbook', // "Guestbook" in your language
);Notices above will get fixed, but this has nothing to do with your admin issues...
-
They are just notices of lacking (optional) variable declaration, not errors.
But...oops, I forgot to include language files edits in the installations instructions: :-[ now they are in place in the first post.
For your convenience I write them here too : open lang/your_lang.php and add this code at the end of the file (just before ?> ):
// ------------------------------------------------------------------------- //
// File guestbook.php
// ------------------------------------------------------------------------- //
$lang_guestbook_php = array(
'title' => 'Guestbook', // "Guestbook" in your language
);Notices above will get fixed, but this has nothing to do with your admin issues...
I have not yet entered above, BUT I had my settings set on English, now i changed them to Dutch and suddenly I can get into the admin............. :D ;D
The only problem i see now that although I changed the setting in Guestbook admin to Dutch, it still stays English, while there are dutch translations available, maybe above change can help that also.
Keep you posted.
Cath
-
Hmm, after the change I get when I enter the admin:
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/dutch.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 48
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/dutch.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 49
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/dutch.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 50
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/dutch.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 51
and the admin stays english, but thats no problem. The Guestbook output is in dutch anyway.
-
Remove the blank line or whatever you have at the start of guestbook/lang/dutch.php
-
Remove the blank line or whatever you have at the start of guestbook/lang/dutch.php
Nibbler, there was a blank line, but it didnt do the trick, still the same errors.
Here is the code of dutch.php, maybe you can see what is wrong?
<?php
/*************************************************************************
Advanced Guestbook 2.4.3 (PHP/MySQL)
Copyright (c) Chi Kien Uong
URL: http://www.proxy2.de
Coppermine integration
Copyright (c) 2008 Gian Luigi Rocca
URL: http://vanrokken.altervista.org/
**************************************************************************
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
**************************************************************************/
# General
$LANG["metatag"] = "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">";
$LANG["BookMess1"] = "HTML is niet actief";
$LANG["BookMess2"] = "HTML is actief";
$LANG["BookMess3"] = "Teken het gastenboek";
$LANG["BookMess4"] = "Terug naar het gastenboek";
$LANG["BookMess5"] = "Onderhoud";
$LANG["BookMess6"] = "Welkom op onze site. Hier kunt u het gastenboek tekenen (zie link rechts)";
$LANG["BookMess7"] = "Commentaar";
$LANG["BookMess8"] = "Terug naar het invoerscherm";
$LANG["BookMess9"] = "Geef commentaar op dit bericht";
$LANG["BookMess10"] = "<br>Bedankt voor uw bijdrage.Uw bericht is met succes toegevoegd aan het gastenboek.<br>U gaat nu binnen 2 seconden automatisch terug naar het gastenboek.<br>";
$LANG["EmailAdminSubject"] = "Nieuw bericht";
$LANG["EmailGuestSubject"] = "Bedankt voor het tekenen van het gastenboek.";
$LANG["AltIP"] = "IP-adres genoteerd";
$LANG["AltICQ"] = "Verstuur ICQ Bericht";
$LANG["AltEmail"] = "Verstuur E-mail";
$LANG["AltUrl"] = "Bekijk Webpagina";
$LANG["AltAim"] = "Instant Messenger";
$LANG["AltCom"] = "Geef commentaar";
# Form
$LANG["FormMess1"] = "Vul onderstaande velden in om een bericht achter te laten. Velden met een (*) zijn verplicht, de andere zijn optioneel.<BR> Om spam te voorkomen moet er onderaan ter bevestiging een veiligheidscode ingevoerd worden.";
$LANG["FormMess2"] = "Smilies staan AAN";
$LANG["FormMess3"] = "AGCode is AAN";
$LANG["FormMess4"] = "Toon legenda";
$LANG["FormMess5"] = "Hieronder staat je bericht.";
$LANG["FormMess6"] = "AG Code is UIT";
$LANG["FormMess7"] = "Smilies staan UIT";
$LANG["FormName"] = "Naam";
$LANG["FormEmail"] = "Email adres";
$LANG["FormLoc"] = "Plaats";
$LANG["FormPic"] = "Plaatje";
$LANG["FormUrl"] = "Homepage";
$LANG["FormGender"] = "Geslacht";
$LANG["FormMale"] = "Man";
$LANG["FormFemale"] = "Vrouw";
$LANG["FormMessage"] = "Uw bericht";
$LANG["FormSelect"] = "Gastenboek";
$LANG["FormUser"] = "gebruikersnaam";
$LANG["FormPass"] = "Wachtwoord";
$LANG["FormReset"] = "Reset";
$LANG["FormSubmit"] = "Verstuur";
$LANG["FormPreview"] = "Voorbeeld";
$LANG["FormBack"] = "Ga terug";
$LANG["FormEnter"] = "Gastenboek - Onderhoud<br>Voordat u verder kunt, dient u een geldige loginnaam en wachtwoord in te voeren!";
$LANG["FormButton"] = "Ga naar";
$LANG["FormPriv"] = "Privé bericht";
# Navigation Bar
$LANG["NavTotal"] = "Totaal aantal berichten:";
$LANG["NavRecords"] = "Berichten per pagina:";
$LANG["NavPrev"] = "Vorige pagina";
$LANG["NavNext"] = "Volgende pagina";
# Post Errors
$LANG["ErrorPost1"] = "U hebt geen naam ingevuld. Ga terug en wijzig dit.";
$LANG["ErrorPost2"] = "U bent vergeten het bericht in te vullen. Ga terug en wijzig dit.";
$LANG["ErrorPost3"] = "Uw bericht is te kort of te lang. Ga terug en wijzig dit.";
$LANG["ErrorPost4"] = "Een van de velden bevat een ongeldige waarde.";
$LANG["ErrorPost5"] = "Forum - Fout";
$LANG["ErrorPost6"] = "Bestand is te groot";
$LANG["ErrorPost7"] = "Verkeerd bestandtype";
$LANG["ErrorPost8"] = "Sorry! Er komen op het moment te veel berichten tegelijk binnen. Probeer het straks nog eens!";
$LANG["ErrorPost9"] = "Uw IP-adres is verbannen!";
$LANG["ErrorPost10"] = "Uw bericht bevat woorden die we niet toelaten in dit forum. Ga terug en verander deze.";
$LANG["ErrorPost11"] = "U hebt geen commentaar ingevuld.";
$LANG["PassMess1"] = "Geef een geldige inlognaam en wachtwoord:";
$LANG["PassMess2"] = "Ongeldige inlognaam of wachtwoord. Probeer het nog eens.";
$LANG["PassMess3"] = "Sorry, maar het wachtwoord is niet correct.";
# Days
$weekday[0] = "Zondag";
$weekday[1] = "Maandag";
$weekday[2] = "Dinsdag";
$weekday[3] = "Woensdag";
$weekday[4] = "Donderdag";
$weekday[5] = "Vrijdag";
$weekday[6] = "Zaterdag";
# Months
$months[0] = "Januari";
$months[1] = "Februari";
$months[2] = "Maart";
$months[3] = "April";
$months[4] = "Mei";
$months[5] = "Juni";
$months[6] = "Juli";
$months[7] = "Augustus";
$months[8] = "September";
$months[9] = "October";
$months[10] = "November";
$months[11] = "December";
// -------------------------------------------------------------------------
// File guestbook.php
// -------------------------------------------------------------------------
$lang_guestbook_php = array(
'title' => 'Guestbook', // "Guestbook" in your language
);
?>
-
// ------------------------------------------------------------------------- //
// File guestbook.php
// ------------------------------------------------------------------------- //
$lang_guestbook_php = array(
'title' => 'Guestbook', // "Guestbook" in your language
);This code is to be added to coppermine lang files, not to guestbook ones as you did!
See you tomorrow for more debug...
-
// ------------------------------------------------------------------------- //
// File guestbook.php
// ------------------------------------------------------------------------- //
$lang_guestbook_php = array(
'title' => 'Guestbook', // "Guestbook" in your language
);This code is to be added to coppermine lang files, not to guestbook ones as you did!
See you tomorrow for more debug...
Oops, :o sorry, misunderstood. Thanks for the update. :-*
-
Hmm, still strange, the errors remain, even when I have removed the lines to the coppermine lang files and change to english (which file I have not changed)
As can be seen by these messages;
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/english.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 48
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/english.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 49
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/english.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 50
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lang/english.php:1) in /usr/home/deb11675/domains/fotofantastic.nl/public_html/guestbook/lib/admin.class.php on line 51
-
although I changed the setting in Guestbook admin to Dutch, it still stays English
No bug, guestbook administration isn't localized even in stand-alone package.
-
Hmm, still strange, the errors remain, even when I have removed the lines to the coppermine lang files and change to english (which file I have not changed)
Check for blank lines before <?php and/or after ?> also in
/include/config.inc.php
/guestbook/admin/config.inc.php
-
Hi, Ludo. I upgraded my CPG to your Advanced Guestbook integration and it looks great. Good job. However, I had a few bugs and solved those and narrowed it down to a single problem, but I can't figure it out. Everything looks great and works great, except getting into the admin panel. When I click on the Administration link, a new window opens with the Admin login and I can enter my username and password, but when I hit enter, it returns a 404 - Not Found error, and for some reason, it inserts the guestbook folder name a second time into the URL.
When the login form is showing, the URL in the address bar is mydomain.com/gallery/guestbook/admin.php. After entering my username and password and get the 404, the URL is mydomain.com/gallery/guestbook/guestbook/admin.php. The first URL is the way my directory structure actually exists. I've tried getting in from a new browser window and get the same thing. Login form, enter UN & PW and hit enter and get 404.
I've spent about four hours so far trying to find something in the code that would cause it to insert the second "guestbook" into the URL and I'm not having much luck. I'd appreciate some input as I seem to be heading in the wrong direction. It doesn't affect users, but obviously, I can't do admin things if need be.
Thanks,
Calvinite
-
I tuned guestbook/admin/config.inc.php default settings for a CPG installed in the web root, try to play with $GB_PG["admin"] (i.e. inserting the absolute path) and/or $GB_PG["base_url"]...and let me know!
Anyway, over the web there is at least one (http://www.kremeratief.nl/coppermine/gboek.php) Advanced Guestbook integrated with a CPG installed in a subdirectory, and its owner doesn't seem to have experienced troubles with admin panel: most likely yours are a matter of server settings.
-
Thanks for your quick reply. I truly appreciate it. I inserted the absolute path in $GB_PG["admin"] as you suggested and that corrected the issue. So now there are at least two Advanced Guestbooks integrated with CPG installed in a subdirectory. You have to register to see mine at The Prichard Collection (http://theprichardcollection.com/tpc_gallery/), but there is no waiting period after registering. At least now, if someone else installs this way, the answer is readily available if they have any problems.
I also meant to tell you of an issue I had when I first installed. I was getting an error in the form of a line of text appeared at the top of the page. I can't recall the exact message but it was something to do with an unexpected character in the language file on a certain line number. I discovered there is a missing character in the code that is to be inserted in the language file from readme.txt.
This line of code from readme.txt has a missing single quotation mark after the first Guestbook.
'title' => 'Guestbook, // "Guestbook" in your language
I inserted the missing character and that corrected the issue I was having.
'title' => 'Guestbook', // "Guestbook" in your language
I downloaded again from the link in this thread to make sure I hadn't unintentionally deleted the character, as I've been known to do such things, and confirmed it is missing in the zip file.
Again, thanks for your help and kudos on the integration. It looks much better than the way I did it and it uses the CPG database.
-
Okay, I don't know what happened, but now I'm getting a MySQL connection error when I click on the Guestbook link.
MySQL Error: Connection Error
Error Number: 1045 Access denied for user 'user'@'localhost' (using password: NO)
Any ideas why it stopped passing the CPG info?
-
Thanks for your quick reply. I truly appreciate it. I inserted the absolute path in $GB_PG["admin"] as you suggested and that corrected the issue.
Uhm, I'd rather have changed to full web URL the path in $GB_PG["base url"]. Would you please try this way (reverting to /guestbook/admin.php the path in $GB_PG["admin"]) and check if this solves the issue too?
This line of code from readme.txt has a missing single quotation mark after the first Guestbook.
Thanks for your notice, I've just released integration package v. 1.0.1, which fixes that typo and upgrades to v. 2.4.4 of Advanced Guestbook
-
Any ideas why it stopped passing the CPG info?
I don't really know, but it can't be due to the edit you made to guestbook/admin/config.inc.php!
-
Well, I'm at a total loss. It worked beautifully the first few times I tried it, except for not being able to get into the admin section. But now, I can log in to the admin section directly via the URL to admin.php, but can't access index.php directly or through CPG.
I also reverted the $GB_PG["admin"] string back to /guestbook/admin.php and changed $GB_PG["base url"] to the full web URL; as you requested. However, that didn't correct the problem with the database error so I can't get into the guestbook to see what difference it made, if any.
When I try to access the index page directly by typing the URL, it gives the same error that it does from inside CPG. Is the guestbook set up to see if it is in CPG and would that make a difference? Could it be "thinking" it is outside CPG and therefore won't grant access. I suppose it would give a custom message, as it does for the wrong password, if it were set up that way though.
-
Is "user" the right username and "localhost" the right host name for your CPG database connection?
Also, try downloading again the package and replace guestbook/admin/config.inc.php with the original file.
-
Well, I finally figured it out, without loosing too much hair. I reinstalled as you suggested, to upgrade to the new version, but it was still giving the same error. After much frustration, I finally came to realize I was pointing the Guestbook link to index.php when it was supposed to be pointed to guestbook.php, which calls index.php (Such a simple blunder to wreck an afternoon). Once I figured that out, the guestbook started working again and looks great.
But that wasn't the last of it. The Guestbook link took me to the admin login page, but when I logged in, it inserted the extra guestbook in the URL. I tried many combinations of URLs in both $GB_PG["base_url"] and $GB_PG["admin"] and ended up puting the full web URL in both, and it now works.
I kept the Guestbook link in the CPG code as I did in my original post, Integrating Advanced Guestbook into CPG (http://forum.coppermine-gallery.net/index.php/topic,55796.0.html), which you replied to and posted your integration. By putting it in the code, it isn't visible without logging in; which is my preference. Others may like it visible, which your method does and redirects to the login if a user is not logged in.
So, I truly appreciate your suggestions and help and I really like your integration. I don't think I'd have been able to figure out these issues without your help.
Ciao!
-
I'm glad you solved your issues, but...would you like to help me finding a generally suitable solution?
In guestbook/admin/config.inc.php, please replace $GB_PG["base_url"] and $GB_PG["admin"] lines with these:
$GB_PG["base_url"] = $CONFIG['ecards_more_pic_target']."guestbook";
$GB_PG["admin"] = "guestbook/admin.php";
Then, open guestbook/templates/admin_enter.php and change
<form method="post" action="$GB_PG[admin]">to
<form method="post" action="$_SERVER[PHP_SELF]">
Now check if admin login (and of course the other admin functions) work fine.
-
LUDO RULES!
Your solution works, now we are both happy campers. I posted a message, logged in to the admin section and deleted it, all with no problems. I'd say this issue is resolved!
'preciate ya!
calvinite
-
Thank you very much, I will upgrade the integration package to v. 1.0.2 ASAP with the new settings
-
You are very welcome. Am I correct in assuming that these updates to the package will now allow the new version of the integration to be installed in the root, or a subdirectory, of a CPG installation and function properly from either location?
-
Yes, it will...better, it should ;D
Maybe even Cath22 issues could get solved (they were admin login-related too)
-
Great. I can't say enough how much I appreciate your help and if I can be of help to you again in the future, let me know.
-
@Ludo: I just try to see the themo and it shows:
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /membri2/vanrokken/lang/spanish.php on line 1276 What version of spanish language file are you using?
-
Fixed.
It wasn't matter of version, but of a comma missing after a definition added by me :-\ :-[
Next upgrade will be guestbook language following automatically the one chosen in Coppermine...
-
Done!
Released version 1.0.2 of integration package, with following updates:
- fixed credits text in admin footer
- now guestbook language follows selection (or default one) in Coppermine
- fixed a bug with admin login (thanks to calvinite)
-
Fixed.
;)
Nice job!
-
Thanks ;)
-
Yes, it will...better, it should ;D
Maybe even Cath22 issues could get solved (they were admin login-related too)
I'm sure going to try it when I find the time. Let you know the results
Greetz
Cath
-
Thanks for the mod Ludo can you tell me how to update my existing guestbook with the new version ?
-
Just replace all files.
-
Thanks Ludo :)
-
Well I have removed all previous guestbook stuff and installed the new one, but guess what...... after succesfull installing, logging in is the same, it accepts my name and password and as soon I click one of the menuoptions i get the login screen again, >:( so it didnt work for me sorry to say.
Cath
-
I added the Advance Guestbook.Type: 2.4.4
After i running the install process, I get these code on the index page:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'hide addresses'@'srv77.one.com' (using password: NO) in
[hide-addresses]bl/guestbook/lib/mysql.class.php on line 45
Connection Error
--------------------------------------------------------------------------------
MySQL Error : Connection Error
Error Number: 1045 Access denied
-
Is /bl your CPG root directory?
Guestbook gathers database connection parameters by including /include/config.inc.php, so the only reason to get a db connection error is a wrong guestbook directory placement, if CPG works.
-
Is /bl your CPG root directory?
Yes ;) it's the gallery root
-
Yes ;) it's the gallery root
The gallery folder are in www.mypage.be/bl/
bl stay for the gallery.
-
I get these code on the index page:
What do you mean by index page? What page are you trying to access the guestbook from?
-
What do you mean by index page? What page are you trying to access the guestbook from?
mysite.be/bl/guestobook
-
sorry i mean:
mysite.be/bl/guestbook/
-
Post real links instead of dummy placeholders.
-
mysite.be/bl/guestbook/
Now you can access guestbook from /guestbook.php (i.e. http://www.yourcpg.tld/guestbook.php)
::) :-X
-
Integration v. 1.0.3 released
Now you can have your guestbook act like a contact form, by placing in your sys or sub menu a "Contact us" link to
/guestbook.php?file=addentry&gb_private=1"Private message" flag in the "add entry" page will be automatically selected, so that message sent by user will appear only in admin panel "Private message" section and in your mailbox (if you have enabled private messages notification by email). A convenient header is displayed on top of the form (English and Italian only, other languages need adapting translation).
-
Heya,
I searched the board and found this thread and it is really, really helpful.
I just started to work with coppermine so I am quiet new to all this. I guess I miss a tiny piece to make it work like the demo that was posted in the first post of this thread. Maybe someone can tell me what I do wrong? I use the greenflower-template. I changed some colors and stuff but atm I have set it back to the original greenflower-template so the changes, that I made myself, are not the reason for my problem.
1. Link to my gallery:
http://www.yinadriel.de/gallery/
2. Link to the guestbook:
http://www.yinadriel.de/gallery/guestbook.php
You see that the sidebar and the footer vanished and I absolutely have no idea why. ???
I am happy if someone answers or gives me a hint what I can try to solve this. Thank you.
-
Move /guestbook directory to your Coppermine root, as per installation instructions.
-
All my coppermine files are in Yinadriel.de/gallery so gallery is my Coppermine root.
-
Argh, hit Enter by accident. So sorry for the double-post.
What I tried to type is that I have in gallery (coppermine root) the file guestbook.php and another directory named guestbook with all the files from the installation of the Advanced guestbook.
yinadriel.de/gallery/guesbook.php
yinadriel.de/gallery/guestbook/*.php
-
Quite strange.
Did you edit /guestbook/admin/config.inc.php?
-
Yes, I edited that file.
Updated the info for the database, the base_url and the email only though.
-
You shouldn't, as per installations instructions.
Restore the original from downloaded archive.
-
hmmm.. now you confuse me. ???
In the guestbook/doc/readme.txt is written:
Installation:
1. Open the configuration file 'config.inc.php' with a text editor and set up your database settings.
That is what I have done.
Weird thing is that the advanced guestbook itself runs well. Like you can see if you try http://www.yinadriel.de/gallery/guestbook/
The problem is it just not works when it is in coppermine. http://www.yinadriel.de/gallery/guestbook.php
Maybe you have another hint for me what to look up?
-
hmmm.. now you confuse me. ???
In the guestbook/doc/readme.txt is written:
That is the original readme file for Advanced Guestbook standalone version.
Coppermine integration installation instructions are in the very first post of this thread and in readme file in main directory of attached archive.
Do as suggested in my previous post.
-
Ah, I see. I was not home yesterday and will try this evening, when I am home. :)
-
I guess my mistake was one of my biggest "blonde moments" ever. :-[
It works perfectly now. Thanks so much, Ludo, for your time and patience. :D
I am very happy with my guestbook in my coppermine now.
-
A couple of days I integrated the AGB into my coppermine website.
Working great but it has its limitations.
I like to use the spin off guestbook called Lazarus.
I has some nice additional features.
I tried installed Lazarus and upgraded it from AGB but I cannot get it to work.
Has someone tried to integrate the Lazarus Guestbook into coppermine?
I like to know how it is done.
Harald
www.haraldlabout.nl/fotografie
-
You're off topic here: open your own thread with your request.
-
I installed the mod and the admin area works perrfect, but when I try to access the guestbook, I get this:
MySQL Error : Connection Error
Error Number: 2002 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
-
What's your CPG root, and where did you extract guestbook files?
What page do you access guestbook from?
Did you edit /guestbook/admin/config.inc.php?
-
Got it to work.
I was trying to access the index file in the /guestbook instead of the root/guestbook.php
I will think before posting next time.
Sorry for the wast of time.
It works great.....
Gracias
-
Hi,
thanks for that great guestbook.
It works like a charme.
But I have 2 smaller issues with it.
1. German language:
The special characters of the German language are totally corretly shown within the guestbook (like ä,ö...)
But when I receive the notification email, the HTML translation is shown, not the transformed once. So ä is Ä
Any idea?
2. Added pictures:
I am able to add pictures and I am able to see them in the guestbook.
But clicking on them, the preview popup comes up, showing no picture at all.
Any idea?
And last one remaining questions.
The two computers in each guestbook post are blinking. Does that mean, that the guy is online?
Thx in advance.
Forty2
-
Hi,
thanks for that great guestbook.
It works like a charme.
Thanks a lot :)
The special characters of the German language are totally corretly shown within the guestbook (like ä,ö...)
But when I receive the notification email, the HTML translation is shown, not the transformed once. So ä is Ä
Any idea?
Change encoding to UTF-8 in your email client. :P
I am able to add pictures and I am able to see them in the guestbook.
But clicking on them, the preview popup comes up, showing no picture at all.
Any idea?
Now it should be fixed, please download the updated archive attached to the first post and give me feedback. The only file changed is /guestbook/picture.php, you have only to replace this file in your installation with the updated one.
The two computers in each guestbook post are blinking. Does that mean, that the guy is online?
No, it doesn't :)
-
Hi,
thank you for that fix within the picture.php.
Now it works perfect.
Forty2
Thanks a lot. :)
Change encoding to UTF-8 in your email client. :P
Now it should be fixed, please download the updated archive attached to the first post and give me feedback. The only file changed is /guestbook/picture.php, you have only to replace this file in your installation with the updated one.
No, it doesn't :)
-
Released version 1.0.4, which includes fix discussed above and a minor fix to admin panel footer
-
Released version 1.0.4, which includes fix discussed above and a minor fix to admin panel footer
Hi,
once more I have a question.
Directly after the installation of the guestbook everything worked fine.
But now, the email notification does not work any more.
I have the following settings:
send e-mail to webmaster (private messages)
send e-mail to webmaster
send e-mail to guest
All of them are marked.
Did I miss something?
Thx.
Forty2
-
Do you mean that this email issue happened after upgrading to 1.0.4?
Anyway, I've just tried leaving a message in my guestbook and I regularly received notification via email ;)
-
Do you mean that this email issue happened after upgrading to 1.0.4?
Anyway, I've just tried leaving a message in my guestbook and I regularly received notification via email ;)
Hi,
no I did not upgrade to 1.0.4 until now.
The email notification worked for some times, but now it does not anymore.
-
The special characters of the German language are totally corretly shown within the guestbook (like ä,ö...)
But when I receive the notification email, the HTML translation is shown, not the transformed once. So ä is Ä
Any idea?
Change encoding to UTF-8 in your email client. :P
I reconsidered this issue as a bug, as it's possible to set email content-type and charset via PHP code, instead of yielding to client server setting.
Please try this mod:
OPEN
guestbook/lib/add.class.php
FIND (2 times)
From: $from_email\nX-Mailer: Advanced Guestbook 2");
BEFORE, ADD:
Content-Type: text/html; charset=utf-8\n
FIND
From: ".$this->db->VARS['admin_mail']."\nX-Mailer: Advanced Guestbook 2");
BEFORE, ADD:
Content-Type: text/html; charset=utf-8\n
SAVE AND CLOSE
If it works, I will release it in 1.0.5 version.
-
Ludo,
I have a simular problem, as mentioned by Forty 2, on my coppermine gallery with the advanced gustebook.
Using coppermine 1.4.26 with advanced guestbook 1.0.3 on my gallery: www.haraldlabout.nl
When someone uses a 's like in foto's it shows up as 's so foto's transforms in foto's.
I know it has to do with the character set encoding.
My coppermine gallery is set to UTF-8.
I tried the above mentioned code, same result still 's when a 's is used.
I posted a question about this before, see http://forum.coppermine-gallery.net/index.php/topic,64646.msg321080.html#msg321080
I was told my whole database should be converted using the charset manager.
Never don this because I don't know how to do this.
Perhaps you have another tip for my correcting this problem.
Dispite this small problem I just love the guestbook and i have a perfect match with my gellery.
When the 's shows up I can always correct it using the administrator function.
Harald
-
p.s. ref above post.
When I run the charsetmgr.php the first message is: Your site is already configured to use utf-8. You don't need this script and should leave this page.
-
I notice that your guestbook page charset is set to iso-8859-1, almost surely this is the issue.
Check charset in your gallery lang file, please.
-
Ludo,
Thanks for the reply.
How do I check this?
My settings in coppermine are UTF-8.
Harald
-
Look for the variable $lang_charset in lang/dutch.php or whatever language you are using: it must be set to utf-8 too.
-
Found this im my dutch lang file:
$lang_charset = 'utf-8';
Should I set this to iso-8859-1?
Again thanks for the reply.
Harald
-
No, it's right, but then there must be something wrong with your template.html file, if charset in <head> section of your pages is set to iso-8859-1!
Please post it.
-
Ludo,
Found: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
Changed it in: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
No result, still same behavior.
Harald
-
Your pages' charset is still set to iso-8859-1, please post your actual template.html
-
Sorry my mistake.
Here is the template.html file.
Harald
-
As I've been supposing, the issue was there.
Change
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />to
<meta http-equiv="Content-Type" content="text/html; charset={CHARSET}" />to have it fixed.
-
Ludo,
Again thanks for your help.
Changed the code, still no luck.
Foto's show up as foto's
Harald
-
Oh, shit...
Please leave one test message in your guestbook, I will take it a look.
I reckon last chance is your guestbook tables charset not set to utf-8...you should check this in your phpMyAdmin or whatever MySQL admin tool your are using
-
Ludo,
Test entry made.
Tried to install and use phpMyadmin, no result, just a blank screen after selecting phpMyadmin.
Working on that.
Harald
-
I've just now noticed that your guestbook lacks credits and copyright. Please restore them, or no more support.
-
Ludo,
Sorry for that, I just adapted the guestbook to my theme.
Will try to revert and add that information when it is important to you.
Is it okay to place this information in the header/footer using a text data filed?
Harald
-
Ludo,
Installed original Footer.
Harald
-
Thank you, it's important not only to give credits, but also to verify what version is installed.
Well, I notice that on your pages the ampersand in the HTML entity ' gets converted to HTML entity &, while in mine it's rendered correctly. I will first compare version I have installed with one in the archive, should they not match...but they're supposed to.
-
But first of all, could you please check if in your guestbook database the phrase "Foto's" is stored like
Foto'sor
Foto&#39;s?
-
[ot]
The plural of "foto" is "fotos" in all Indo-European languages that I'm aware of. None of them creates the plural with an apostrophe. Therefore, the best method in terms of orthography, grammar and functionality is to replace "Foto's" with "Fotos".
[/ot]
-
Joachim,
Fotos would be nice but everyone in the nederlands that is writing in my guest book uses foto's.
Afterwards I correct the entries using the admin function in the guestbook but I get a lot of comments that my guestbook is not working properly.
Perhaps not a big problem but when I can get things solved it is better to do that.
Ludo,
Where can I check my guestbook database, phmyadmin is not working at this moment on my gallery (blank screen after selecting)!
Harald
-
You should get it running, I don't know another way to check database entries :-\
-
Hello,
I have installed the advanced guestbook as per instructions and have applied the correct permissions.
Whilst everything seems to be working ok, when I goto: http://domain/guestbook.php and click 'Leave a message' nothing happens other than the page going to http://domain/guestbook.php?file=addentry
There is nothing showing to enable me to post a comment.
Can you please advise me?
http://coffee-mates.co.uk/guestbook.php
(am using: Coppermine 1.5.8 stable)
Many thanks
-
This mod was written for Coppermine 1.4. It won't work on 1.5.
-
Ahhh... I see. Thanks for the reply.
-
Ludo,
Accessed my SQL database with phpmyadmin through my hosting company admintools.
Found the phrase foto's stored as foto&#39;s in my database.
Harald
-
I've just made a "live test" of version 1.0.4 of integration package, on this site's guestbook:
http://foto.oplustil.cz/gallery/guestbook.php (http://foto.oplustil.cz/gallery/guestbook.php)
As you can see it works correctly, your troubles are likely due to some setting in your database...
-
Ludo,
Thanks for all your help and patience.
Perhaps it is best to delete my database and start all over again.
I hope i can fix this problem in the future.
Harald
-
ludo ho seguito le tue istruzioni ma non riesco a farlo funzionare ... non mi si connette al database ... sapresti aiutarmi ??? grazie mille
-
Only English postings are allowed here!
-
This mod was written for Coppermine 1.4. It won't work on 1.5.
Hi,
would you be able to deliver an update for the coppermine version 1.5?
Would be great.
Thx.
Forty2
-
Hi Ludo,
I upgraded my Coppermine installation to version 1.5.12 when the upgrade first came out, and a few weeks later I noticed that the link I had made for the Advanced Guestbook integration was no longer there.
Some time passed, due to the daily grind, before I was able to rework my code and get the link working again. I posted update instructions for anyone that had used my method. (See http://forum.coppermine-gallery.net/index.php/topic,55796.msg350653.html#msg350653)
However, there is a problem. When clicked, the guestbook opens inside Coppermine, as it should. The Administration link works and lets me log in to the admin panel; but when the 'Sign the Guestbook' link is clicked, the guestbook "blinks" but does not go to the 'Sign the Guestbook' form, so no one can sign the guestbook. :'(
Do you have any idea as to why the 'Sign the Guestbook' link is no longer functioning? I didn't modify any code within the guestbook installation, only my link code. I'd appreciate any help you may be able give.
Thanks,
calvinite
-
I wish I knew.
Same problem.
It has something to do with CPG 1.5.x..
Maybe one day someone I able to fix this.
Edward