• [MOD] guestbook 5 0 5 1
Currently:  

Author Topic: [MOD] guestbook  (Read 526717 times)

0 Members and 1 Guest are viewing this topic.

Offline Alex_Ok

  • Jr. Member
  • **
  • Posts: 66
    • View Profile
Re: [MOD] guestbook
« Reply #120 on: January 29, 2006, 07:28:39 PM »
Подскажите почему не выводятся сообщения на страничку гостевой, хотя в базу всё идёт нормально? :?:

Offline Frebee

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: [MOD] guestbook
« Reply #121 on: January 30, 2006, 01:45:47 AM »
Hi !

Hab 2 Fehler

1. Ich finde keinen Link auf der Home Seite fürs Gästebuch !

2. Wenn ich direkt auf die Url gehe ./guestbook.php kommt zwar des gästebuch aber ohne den rest vom Template

Link : http://nmf.mine.nu/smc/4images/index.php

MfG Frebee


Offline Miranda

  • Pre-Newbie
  • Posts: 9
    • View Profile
    • Mirandus-Arts
Re: [MOD] guestbook
« Reply #122 on: February 11, 2006, 05:20:28 PM »
Hi,

ich versuche auch gerade das Gästebuch einzubauen und mir fehlt die Datei "http://140.112.132.43/install_guestbook.zip"
Die Datei wurde auf dem Server nicht gefunden. Kann da evtl. jemand aushelfen ?

Danke,
Miranda

Offline Olphi

  • Full Member
  • ***
  • Posts: 101
    • View Profile
Re: [MOD] guestbook
« Reply #123 on: February 11, 2006, 06:57:43 PM »
 :wink:

Offline TheOracle

  • Hero Member
  • *****
  • Posts: 875
    • View Profile
Re: [MOD] guestbook
« Reply #124 on: February 11, 2006, 07:02:09 PM »
A little security precaution from this installation file.

Find :

Quote

require(ROOT_PATH.'includes/sessions.php');


add below :

Code: [Select]

$user_access = get_permission();

if ($user_info['user_level'] != ADMIN) {
show_error_page($lang['no_permission']);
} ###### End of if statement.


Then, log in under your admin account and run this file after. Once successfully executed, you may delete this file. ;)

Offline Miranda

  • Pre-Newbie
  • Posts: 9
    • View Profile
    • Mirandus-Arts
Re: [MOD] guestbook
« Reply #125 on: February 11, 2006, 11:50:27 PM »

Offline Svenni70

  • Newbie
  • *
  • Posts: 14
    • View Profile
    • svenni.org
db trouble
« Reply #126 on: February 12, 2006, 02:21:26 PM »
Hello

i get this after i run the install_guestbook.php

DB Error: Bad SQL Query: INSERT INTO 4images_1settings (setting_name, setting_value) VALUES ('guestbook_view', '1')
Duplicate entry 'guestbook_view' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_1settings (setting_name, setting_value) VALUES ('user_delete_guestbook', '0')
Duplicate entry 'user_delete_guestbook' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_1settings (setting_name, setting_value) VALUES ('guestbook_post', '1')
Duplicate entry 'guestbook_post' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_1settings (setting_name, setting_value) VALUES ('user_edit_guestbook', '0')
Duplicate entry 'user_edit_guestbook' for key 1

DB Error: Bad SQL Query: CREATE TABLE `4images_guestbook` ( `comment_id` mediumint(8) NOT NULL auto_increment, `user_name` varchar(100) NOT NULL default '', `comment_site` varchar(255) NOT NULL default '', `comment_date` int(10) unsigned NOT NULL default '0', `comment_text` text NOT NULL, `comment_ip` varchar(20) NOT NULL default '', PRIMARY KEY (`comment_id`), KEY `comment_date` (`comment_date`) ) TYPE=MyISAM
Table '4images_guestbook' already exists


maybe someone no wgat i can do to fix it

Svenni
Svenni

Offline IcEcReaM

  • Hero Member
  • *****
  • Posts: 714
    • View Profile
    • My little Testboard
Re: [MOD] guestbook
« Reply #127 on: February 13, 2006, 08:29:04 AM »
Then you already executed the install before,
cause all needed DB entries are already made.

If you already had all other installtion steps,
you can try it now, it should work.
Coding is a everlasting competition between programmers who tries to write larger, better and idiot-safe programs and the universe producing larger and stupider idiots...
...so far the universe won
bump

Offline Svenni70

  • Newbie
  • *
  • Posts: 14
    • View Profile
    • svenni.org
Re: [MOD] guestbook
« Reply #128 on: February 13, 2006, 11:03:42 AM »
when i trey to open the guestbook i get this message

Warning: Cannot send session cache limiter - headers already sent (output started at /home/sites/site6/web/foto/guestbook.php:2) in /home/sites/site6/web/foto/includes/sessions.php on line 84

DB Error: Bad SQL Query: SELECT COUNT(user_name) AS comments FROM 4images_1guestbook
Table 'svenn21.4images_1guestbook' doesn't exist

DB Error: Bad SQL Query: SELECT comment_id, user_name AS comment_user_name, comment_site, comment_text, comment_ip, comment_date FROM 4images_1guestbook ORDER BY comment_date DESC LIMIT 0, 8
Table 'svenn21.4images_1guestbook' doesn't exist

Fatal error: Call to undefined function: get_smiles_text() in /home/sites/site6/web/foto/guestbook.php on line 363
Svenni

Offline IcEcReaM

  • Hero Member
  • *****
  • Posts: 714
    • View Profile
    • My little Testboard
Re: [MOD] guestbook
« Reply #129 on: February 13, 2006, 11:57:02 AM »
Look at your includes/constants.php
Search for the line:
Code: [Select]
define('GUESTBOOK_TABLE', $table_prefix.'1guestbook');
the line must be
Code: [Select]
define('GUESTBOOK_TABLE', $table_prefix.'guestbook');
if you can't find it, please post your constants.php here.
Coding is a everlasting competition between programmers who tries to write larger, better and idiot-safe programs and the universe producing larger and stupider idiots...
...so far the universe won
bump

Offline Svenni70

  • Newbie
  • *
  • Posts: 14
    • View Profile
    • svenni.org
Re: [MOD] guestbook
« Reply #130 on: February 13, 2006, 12:19:26 PM »
i cheek the file,and it is the corect file

 define('GUESTBOOK_TABLE', $table_prefix.'guestbook');
Svenni

Offline TheOracle

  • Hero Member
  • *****
  • Posts: 875
    • View Profile
Re: [MOD] guestbook
« Reply #131 on: February 13, 2006, 12:29:35 PM »
Quote

Fatal error: Call to undefined function: get_smiles_text() in /home/sites/site6/web/foto/guestbook.php on line 363


In the mean time, you might want to follow the latest code block from the first post in order to remove the smilies line from guestbook.php file. ;)

Also, if you have the correct definition table from includes/constants.php file, which mySQL version are you using ? mySQL 5 probably ?

Offline Svenni70

  • Newbie
  • *
  • Posts: 14
    • View Profile
    • svenni.org
Re: [MOD] guestbook
« Reply #132 on: February 13, 2006, 12:32:15 PM »
hello

im new in this things  :roll: what is the latest code
Svenni

Offline IcEcReaM

  • Hero Member
  • *****
  • Posts: 714
    • View Profile
    • My little Testboard
Re: [MOD] guestbook
« Reply #133 on: February 13, 2006, 01:18:07 PM »
hello

im new in this things  :roll: what is the latest code
^

he means the last error message with the smileys.
This problem has here solved already in the prevoius posts.

Coding is a everlasting competition between programmers who tries to write larger, better and idiot-safe programs and the universe producing larger and stupider idiots...
...so far the universe won
bump

Offline Svenni70

  • Newbie
  • *
  • Posts: 14
    • View Profile
    • svenni.org
Re: [MOD] guestbook
« Reply #134 on: February 13, 2006, 02:57:51 PM »
no i only get this messages 

DB Error: Bad SQL Query: SELECT COUNT(user_name) AS comments FROM 4images_1guestbook
Table 'svenn21.4images_1guestbook' doesn't exist

DB Error: Bad SQL Query: SELECT comment_id, user_name AS comment_user_name, comment_site, comment_text, comment_ip, comment_date FROM 4images_1guestbook ORDER BY comment_date DESC LIMIT 0, 8
Table 'svenn21.4images_1guestbook' doesn't exist

i removed the get_smiles_text() line,and i can no se the page   http://www.svenni.net/foto/guestbook.php


my sql is mysql 3
Svenni