Error while trying to connect to table ""

mike444 · Post by **mike444** » Wed 30. Jun 2004, 15:46

Hi, habe PHPwcms installiert, alle rechte sind richtig vergeben, Tabellen wurden angelegt und die conf.inc.php scheint auch zu stimmen.

Aber ich bekomme immer beim Einloggen diesen Error:
Error while trying to connect to table ""

Hier ist meine conf.inc.php und weiter unten der Inhalt von PHPmyAdmin:

Code: Select all

<?php

// database values
$phpwcms["db_host"]           = "project.de";
$phpwcms["db_user"]           = "v034528";
$phpwcms["db_pass"]           = "******";
$phpwcms["db_table"]          = "v034528";
$phpwcms["db_prepend"]        = "phpwcms";
$phpwcms["db_pers"]           = 1;

// site values
$phpwcms["site"]              = "http://www.project.de/";
$phpwcms["admin_email"]       = "";

// paths
$phpwcms["root"]         		= "phpwcms";         //default: ""
$phpwcms["file_path"]         = "phpwcms_filestorage";    //default: "phpwcms_filestorage"
$phpwcms["file_tmp"]          = "phpwcms_tmp";     //default: "phpwcms_tmp"
$phpwcms["templates"]         = "phpwcms_template";    //default: "phpwcms_template"
$phpwcms["dir_thlist"]        = "thumb_list";   //default: "thumb_list"
$phpwcms["dir_preview"]       = "thumb_preview";  //default: "thumb_preview"
$phpwcms["content_path"]      = "content"; //default: "content"
$phpwcms["cimage_path"]       = "images";  //default: "images"
$phpwcms["ftp_path"]          = "phpwcms_ftp";     //default: "phpwcms_ftp"

// content values
$phpwcms["file_maxsize"]      = 2097152; //Bytes (50 x 1024 x 1024)
$phpwcms["content_width"]     = 538; //max width of the article content column - important for rendering multi column images
$phpwcms["img_list_width"]    = 100; //max with of the list thumbnail image
$phpwcms["img_list_height"]   = 75; //max height of the list thumbnail image
$phpwcms["img_prev_width"]    = 538; //max width of the large preview image
$phpwcms["img_prev_height"]   = 400; //max height of the large preview image
$phpwcms["max_time"]          = 1800; //logout after max_time/60 seconds

// other stuff
$phpwcms["compress_page"]     = 0; //0 = OFF, 1-9: page compression ON (1 = low level, 9 = highest level)
$phpwcms["imagick"]           = 0; //0 = GD,  1 = ImageMagick, 2 = ImageMagick 4.2.9
$phpwcms["imagick_path"]      = ""; //Path to ImageMagick (default="" - none)
$phpwcms["use_gd2"]           = 1; //0 = GD1, 1 = GD2
$phpwcms["rewrite_url"]       = 0;  //whether URL should be rewritable
$phpwcms["wysiwyg_editor"]    = 3;  //0 = no wysiwyg editor, 1 = HTMLarea, 2 = FCKeditor, 3 = browser based
$phpwcms["phpmyadmin"]        = 1;  //enable/disable phpMyAdmin in Backend
$phpwcms["default_lang"]      = "en";  //default language
$phpwcms["charset"]           = "iso-8859-1";  //default charset 'iso-8859-1'
$phpwcms["allow_remote_URL"]  = 0;  //0 = no remote URL in {PHP:...} replacement tag allowed, 1 = allowed
$phpwcms["gt_mod"]            = 0;  //0 = Graphical Text MOD disabled, 1 = enabled

// dynamic ssl encryption engine
$phpwcms["site_ssl_mode"]     = '0'; // tuns the SSL Support of WCMS on(1) or off (0) DEFAULT '0'
$phpwcms["site_ssl_url"]      = '';  //URL assigned to the SSL Certificate. DON'T add a slash at the End! Exp. "https://www.yourdomainhere.tld"
$phpwcms["site_ssl_port"]     = '443'; //The Port on which you SSL Service serve the secure Sites. Servers DEFAULT is '443'

// smtp values
$phpwcms['SMTP_FROM_EMAIL']   = 'michael.zenkel@z-com.de'; // reply/from email address
$phpwcms['SMTP_FROM_NAME']    = 'phpwcms webmaster'; // reply/from name
$phpwcms['SMTP_HOST']         = 'localhost'; // SMTP server (host/IP)
$phpwcms['SMTP_PORT']         = 25; // SMTP-Server port (default 25)
$phpwcms['SMTP_MAILER']       = 'mail'; // default phpMailer: smtp, mail (default), sendmail
$phpwcms['SMTP_AUTH']         = 0; // sets SMTP_AUTH to ON/OFF
$phpwcms['SMTP_USER']         = ''; // default SMTP login (user) name
$phpwcms['SMTP_PASS']         = ''; // default SMTP password


// Try to check and uncomment the DOCUMENT_ROOT if you have problems 
// often neccessary on IIS or default MacOS X webserver settings
// Do not use backslash "\" on Windows - always replace "\" by "/"
//$_SERVER['DOCUMENT_ROOT']     = '/www/htdocs/v034528/';


?>

phpwcms_phpwcms_address Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_article Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_articlecat Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_articlecontent Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_bid Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_blog Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_chat Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_country Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 239 MyISAM 9,6 KB -
phpwcms_phpwcms_file Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_filecat Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_filekey Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_fonts Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_fonts_colors Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_fonts_styles Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_guestbook Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_log Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_message Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_newsletter Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_pagelayout Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_profession Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 22 MyISAM 2,5 KB -
phpwcms_phpwcms_results Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_resultscat Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_schedule Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_schedulecat Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_subscription Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_template Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_user Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_userdetail Anzeigen Suche Einfügen Eigenschaften Löschen Leeren 0 MyISAM 1,0 KB -
phpwcms_phpwcms_userlog

mike444 · Post by **mike444** » Wed 30. Jun 2004, 16:01

it was "phpwcms_"

rai · Post by **rai** » Tue 13. Jul 2004, 16:03

...das Problem hatt ich auch - bin aber ein Newbie, deswegen weiß ich nicht was das heißt, mike444, wenn du sagst: it was "phpwcms_"!?

Pappnase · Post by **Pappnase** » Tue 13. Jul 2004, 16:20

rai wrote:...das Problem hatt ich auch - bin aber ein Newbie, deswegen weiß ich nicht was das heißt, mike444, wenn du sagst: it was "phpwcms_"!?

hello

he means that he fillout at the setup the prepend field.

Code: Select all

$phpwcms["db_prepend"]        = "phpwcms";

what is not really needed execpt you install phpwcms a several times at one domain/webspace.

rai · Post by **rai** » Tue 27. Jul 2004, 17:53

...here I am again with the next part of the story:

I corrected "phpwcms" to "phpwcms_"...alright...now I get a blank page instead of a page that says: "Error while trying to connect to table"...????

Pappnase · Post by **Pappnase** » Tue 27. Jul 2004, 17:59

hello

then you have

1. not the conf.inc.php uploaded
2. wrong database setttings
3. wrong database pretend

did you write soemthing in the filed db pretend in the setup script!?
look into your database and look how the tables are called there.

rai · Post by **rai** » Tue 27. Jul 2004, 18:27

...I did it all again...uninstall...install...now I finally got to the Login at least and I was happy...

but: he doesn´t accept my login data ??!!

is in the script something wrong???

// phpwcms base values -> needed in any document

// database values
$phpwcms["db_host"] = "localhost";
$phpwcms["db_user"] = "*******";
$phpwcms["db_pass"] = "*******";
$phpwcms["db_table"] = "********";
$phpwcms["db_prepend"] = "phpwcms_";
$phpwcms["db_pers"] = 1;

// site values
$phpwcms["site"] = "http://www.*****.de/phpwcms";
$phpwcms["admin_email"] = "";

// paths
$phpwcms["root"] = "";
$phpwcms["file_path"] = "phpwcms_filestorage";
$phpwcms["file_tmp"] = "phpwcms_tmp";
$phpwcms["templates"] = "phpwcms_template";
$phpwcms["dir_thlist"] = "thumb_list";
$phpwcms["dir_preview"] = "thumb_preview";
$phpwcms["content_path"] = "content";
$phpwcms["cimage_path"] = "images";
$phpwcms["ftp_path"] = "phpwcms_ftp";

// content values
$phpwcms["file_maxsize"] = 52428800; //Bytes (50 x 1024 x 1024)
$phpwcms["content_width"] = 538; //max width of the article content column - important for rendering multi column images
$phpwcms["img_list_width"] = 100; //max with of the list thumbnail image
$phpwcms["img_list_height"] = 75; //max height of the list thumbnail image
$phpwcms["img_prev_width"] = 538; //max width of the large preview image
$phpwcms["img_prev_height"] = 538; //max height of the large preview image
$phpwcms["max_time"] = 1800; //nach wieviel Sekunden soll automatischer logout erfolgen? 1800 Sekunden=30Minuten

// other stuff
$phpwcms["compress_page"] = 3; //wenn 1 = Seite komprimieren, 0 = Kompresion aus
$phpwcms["imagick"] = 0; //if 0 = GD, 1 = ImageMagick convert, 2 = ImageMagick 4.2.9
$phpwcms["imagick_path"] = ""; //Path to ImageMagick
$phpwcms["use_gd2"] = 1; //if 0 = GD1, 1 = GD2
$phpwcms["rewrite_url"] = 0; //whether URL should be rewritable
$phpwcms["wysiwyg_editor"] = 1; //0 = no wysiwyg editor, 1 = HTMLarea, 2 = FCKeditor, 3 = browser based, 4 = spaw
$phpwcms["phpmyadmin"] = 1; //enable/disable phpmyadmin in Admin section
$phpwcms["default_lang"] = "en"; //default language
$phpwcms["charset"] = "iso-8859-1"; //default charset "iso-8859-1"
$phpwcms["allow_remote_URL"] = 0; //0 = no remote URL in {PHP:...} replacement tag allowed, 1 = allowed
$phpwcms["gt_mod"] = 0; //0 = Graphical Text MOD disabled, 1 = enabled

// dynamic ssl encryption engine
$phpwcms["site_ssl_mode"] = "0"; // tuns the SSL Support of WCMS on(1) or off (0) DEFAULT '0'
$phpwcms["site_ssl_url"] = ""; //URL assigned to the SSL Certificate. DON'T add a slash at the End! Exp. "https://www.yourdomainhere.tld"
$phpwcms["site_ssl_port"] = "443"; //The Port on which you SSL Service serve the secure Sites. Servers DEFAULT is '443'

// smtp values
$phpwcms['SMTP_FROM_EMAIL'] = 'info@localhost';
$phpwcms['SMTP_FROM_NAME'] = 'My Name';
$phpwcms['SMTP_HOST'] = 'localhost';
$phpwcms['SMTP_PORT'] = 25;
$phpwcms['SMTP_MAILER'] = 'mail';
$phpwcms['SMTP_AUTH'] = 0;
$phpwcms['SMTP_USER'] = 'user';
$phpwcms['SMTP_PASS'] = 'pass';

and on the other hand: what is this "semi-automatic setup process" in the Documentation good for?? If I insert "http://www.mydomain.com/path_2_phpwcms/setup/index.php" I get an error-message...???!!!

Pappnase · Post by **Pappnase** » Tue 27. Jul 2004, 18:49

hello

did you set the tick at create admin account and create all tables!?

rai · Post by **rai** » Tue 27. Jul 2004, 19:05

[...thanx for your patience, Pappnase]

...where do I do this...? I´m at the very very beginning of the whole procedure and only get to the phpwcms Installation-Welcome which leads me to the Login, then I put in the correct username and password but it always says "Errors during login!"......????????????

Pappnase · Post by **Pappnase** » Tue 27. Jul 2004, 19:11

hello

if you run the setup!

create all tables at the screen where you setup the database settings
admin at the netz setup screen below the admin name and password

DeXXus · Post by **DeXXus** » Tue 27. Jul 2004, 19:45

rai wrote:...I did it all again...uninstall...install...now I finally got to the Login at least and I was happy...

but: he doesn´t accept my login data ??!!

is in the script something wrong???

// site values
$phpwcms["site"] = "http://www.*****.de/phpwcms";

// paths
$phpwcms["root"] = "";

This part does not look right. It should be:

Code: Select all

// site values
$phpwcms["site"]              = "http://www.*****.de/";

// paths
$phpwcms["root"]              = "phpwcms";