Error in query:SELECT * FROM 1_phpwcms_fonts

J. Anthonisen · Post by **J. Anthonisen** » Tue 22. Jun 2004, 19:08

Yes, setting are correct. I could perhaps go into the phpMyAdmin and check user details, however, have never messed around with that app before.

J.

frold · Post by **frold** » Tue 22. Jun 2004, 19:12

J. Anthonisen wrote:Yes, setting are correct. I could perhaps go into the phpMyAdmin and check user details, however, have never messed around with that app before.

J.

eg, delete the folder and the database and reupload and reinstall with the settings we gave you...

just one thing- did you upload the new conf.inc.php?

J. Anthonisen · Post by **J. Anthonisen** » Tue 22. Jun 2004, 19:24

Yes, but it didn't work, so I created a new database, and run setup again (without re-uploading all files). I made sure the root was just "cms" and not "home/html/cms." Seems I can login, so I will take it from there...

A million thanks for your time and help!!

J.

frold · Post by **frold** » Tue 22. Jun 2004, 19:26

J. Anthonisen wrote:Yes, but it didn't work, so I created a new database, and run setup again (without re-uploading all files). I made sure the root was just "cms" and not "home/html/cms." Seems I can login, so I will take it from there...

A million thanks for your time and help!!

J.

just perfect... if you need any help then ask in the forum and we will try to help !

J. Anthonisen · Post by **J. Anthonisen** » Tue 22. Jun 2004, 19:28

Thanks!

Tidida · Post by **Tidida** » Tue 22. Jun 2004, 21:37

Hi,

I got the same error:

Error in query:SELECT * FROM phpwcms_fonts ORDER BY font_name

Here is the code:

Code: Select all

// phpwcms base values -> needed in any document

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

// site values
$phpwcms["site"]              = "http://universoe.com/";
$phpwcms["admin_email"]       = "univer6@universoe.com";

// paths
$phpwcms["root"]              = "WCMS";    //default: ""
$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

// 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']   = 'webmaster@universoe.com';
$phpwcms['SMTP_FROM_NAME']    = 'Administrador';
$phpwcms['SMTP_HOST']         = 'localhost';
$phpwcms['SMTP_PORT']         = 25;
$phpwcms['SMTP_MAILER']       = 'mail';
$phpwcms['SMTP_AUTH']         = 0;
$phpwcms['SMTP_USER']         = 'user';
$phpwcms['SMTP_PASS']         = 'pass';

Any way i think it has to do with the sql db, i used the upgrade.php but i got an error, and when try to publish an article:

Code: Select all

error while updating article basis information:
UPDATE phpwcms_article SET article_cid=1,article_title='Prueba db', article_keyword='', article_public=1, article_aktiv=1, article_begin='2004-06-22 14:29:50', article_end='2010-12-31 23:59:59'....  etc.

What can i do, how do i update the db?

frold · Post by **frold** » Tue 22. Jun 2004, 21:39

Tidida wrote:

Code: Select all

error while updating article basis information:
UPDATE phpwcms_article SET article_cid=1,article_title='Prueba db', article_keyword='', article_public=1, article_aktiv=1, article_begin='2004-06-22 14:29:50', article_end='2010-12-31 23:59:59'....  etc.

What can i do, how do i update the db?

Are you sure that the db not allready exist

eg delete the database created and run this sql instead..

setup\sample_template_db\phpwcm_init.sql

Tidida · Post by **Tidida** » Tue 22. Jun 2004, 22:47

The database already exists and i don't want to erase it i want to update it... well, do i have to? I have 2 errors:

1. Index.php : Error in query:SELECT * FROM phpwcms_fonts ORDER BY font_name

2. Publishing an article: "error while updating article basis information:
UPDATE phpwcms_article SET article_cid=1,article_title= etc... article_uid=1 WHERE article_id=20;

Everything worked fine until i uploded the latest version of the WCMS, i was working with the RC2.

I don't want to erase the db because i don't konw how

and i got some articles in that bd already.

What can i do?

Pappnase · Post by **Pappnase** » Tue 22. Jun 2004, 22:50

Tidida wrote:The database already exists and i don't want to erase it i want to update it... well, do i have to? I have 2 errors:

1. Index.php : Error in query:SELECT * FROM phpwcms_fonts ORDER BY font_name

2. Publishing an article: "error while updating article basis information:
UPDATE phpwcms_article SET article_cid=1,article_title= etc... article_uid=1 WHERE article_id=20;

Everything worked fine until i uploded the latest version of the WCMS, i was working with the RC2.

I don't want to erase the db because i don't konw how and i got some articles in that bd already.

What can i do?

hello

did you execute the upgrade.php in the setup folder!? choose than the phpwcms_update_older.sql file
cos you need also update/upgrade the database!

Tidida · Post by **Tidida** » Tue 22. Jun 2004, 23:02

Hi papanese

did you execute the upgrade.php in the setup folder!? choose than the phpwcms_update_older.sql file
cos you need also update/upgrade the database!

I did, read that before i posted anything and i get this error:

Code: Select all

-- ERROR --
ALTER TABLE `phpwcms_articlecat` ADD `acat_topcount` INT NOT NULL;
-- ERROR --
CREATE TABLE `phpwcms_guestbook` (
  `guestbook_id` int(11) NOT NULL auto_increment,
  `guestbook_cid` int(11) NOT NULL default '0',
  `guestbook_msg` text NOT NULL,
  `guestbook_name` varchar(255) NOT NULL default '',
  `guestbook_email` varchar(255) NOT NULL default '',
  `guestbook_created` varchar(14) NOT NULL default '',
  `guestbook_trashed` int(1) NOT NULL default '0',
ETC...

Could it be that i can't acces the php myadmin through the WCMS but only through cpanel?

Pappnase · Post by **Pappnase** » Tue 22. Jun 2004, 23:22

Tidida wrote:Hi papanese

did you execute the upgrade.php in the setup folder!? choose than the phpwcms_update_older.sql file
cos you need also update/upgrade the database!
I did, read that before i posted anything and i get this error:
Code: Select all
-- ERROR --
ALTER TABLE `phpwcms_articlecat` ADD `acat_topcount` INT NOT NULL;
-- ERROR --
CREATE TABLE `phpwcms_guestbook` (
  `guestbook_id` int(11) NOT NULL auto_increment,
  `guestbook_cid` int(11) NOT NULL default '0',
  `guestbook_msg` text NOT NULL,
  `guestbook_name` varchar(255) NOT NULL default '',
  `guestbook_email` varchar(255) NOT NULL default '',
  `guestbook_created` varchar(14) NOT NULL default '',
  `guestbook_trashed` int(1) NOT NULL default '0',
ETC...
Could it be that i can't acces the php myadmin through the WCMS but only through cpanel?

hello

yes that could also be! one other thing could it be that these tables are already there!?

Tidida · Post by **Tidida** » Wed 23. Jun 2004, 00:07

Papanese Wrote:

yes that could also be! one other thing could it be that these tables are already there!?

If it is because of the cpanel, is there any way that i can run this script automatically through the php myadmin?

And what was that about the tables?

Tidida · Post by **Tidida** » Wed 23. Jun 2004, 00:11

hello

yes that could also be! one other thing could it be that these tables are already there!?

Yes, the tables are already there, i saw in the php myadmin. So what can be the problem?[/quote]

Pappnase · Post by **Pappnase** » Wed 23. Jun 2004, 00:12

hello

if you have the cpanel also phpmyadmin you should also have a field called "QUERY" there you can include the source of the sql file!

and to the sql thing. is it possible that some tables are already included in the phpwcms table?!

Tidida · Post by **Tidida** » Wed 23. Jun 2004, 00:29

I can't be sure what i did but i got this:

Code: Select all

Error

SQL-query :  

CREATE TABLE `phpwcms_guestbook` (

`guestbook_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`guestbook_cid` int( 11 ) NOT NULL default '0',
`guestbook_msg` text NOT NULL ,
`guestbook_name` varchar( 255 ) NOT NULL default '',
`guestbook_email` varchar( 255 ) NOT NULL default '',
`guestbook_created` varchar( 14 ) NOT NULL default '',
`guestbook_trashed` int( 1 ) NOT NULL default '0',
`guestbook_url` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `guestbook_id` ) 
) TYPE = MYISAM AUTO_INCREMENT =1 

MySQL said: 


#1050 - Table 'phpwcms_guestbook' already exists

I accesed the sql db and tried in SQL a Run SQL query/queries on database univer6_wcms1 with the script of update.php

I still get in the index.php: Error in query:SELECT * FROM phpwcms_fonts ORDER BY font_name

I don't understand what to do o how to do it