close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

ERROR: Failed to save the settings in the database. Please verify your database connection.

Thread began 4/25/2014 3:47 pm by elewis93815 | Last modified 5/16/2014 8:22 pm by Jason Byrnes | 6797 views | 15 replies |

elewis93815

ERROR: Failed to save the settings in the database. Please verify your database connection.

We are attempting to set up PowerCMS for an account and we are receiving this error:
ERROR: Failed to save the settings in the database. Please verify your database connection.

Any thoughts???

Thanks,

Jackie

Sign in to reply to this post

Jason ByrnesWebAssist

That error usually happens if most of the PCMS tables already exist in your Database, but there is no wa_settings database.

use the following SQL to create the wa_settings table in your database through phpMyAdmin.

CREATE TABLE `wa_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`type` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`options` text COLLATE latin1_bin,
`value` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`grp` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`subcategory` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`cond` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`description` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`variable` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`weight` float DEFAULT NULL,
`spry_args` text COLLATE latin1_bin,
`spry_error` text COLLATE latin1_bin,
`help_text` text COLLATE latin1_bin,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_bin
Sign in to reply to this post

elewis93815

Thank you Jason,
I did create the database table that you suggested and now I'm getting the following error:

"Table 'sitpfood.pcms2_contents' doesn't exist"

any suggesstions?

Thanks,
Jackie

Sign in to reply to this post

Jason ByrnesWebAssist

For some reason, the tables for the CMS are not being created. you can use the .sql files that are in the install_cms/scripts folder to create them manually. you may need to delete the wa_settings table first.

Sign in to reply to this post

elewis93815

Originally Said By: Jason Byrnes
  For some reason, the tables for the CMS are not being created. you can use the .sql files that are in the install_cms/scripts folder to create them manually. you may need to delete the wa_settings table first.  


Hi Jason,

Deleting the WA_settings table and we are still not able to get past this error: Table 'sitpfood.pcms2_contents' doesn't exist, please advise.

Thanks

Jackie

Sign in to reply to this post

Jason ByrnesWebAssist

you can use the .sql files that are in the install_cms/scripts folder to create them manually.

Sign in to reply to this post

elewis93815

Thanks, I'll give that a try, I'm curious to know if issue has anything to do with godaddy's new c panel configuration?

Thanks

Erick

Sign in to reply to this post

Jason ByrnesWebAssist

I cant realy say what the cause of the problem is.

but the error suggests that the pcms2_contents table is not getting created.

to create that table manually, you can run the .sql files that are in the install_cms/scripts folder

Sign in to reply to this post

elewis93815

Hi Again, I was able to upload the sql db, however now I'm not able to log in, please advise. I've attached the database to this post

Thanks

Erick

Attached Files
sitpfood.sql
Sign in to reply to this post

Jason ByrnesWebAssist

run the following query to create the user and pass records in the wa_settings table.

INSERT INTO `wa_settings` (`id`,`name`,`type`,`options`,`value`,`grp`,`subcategory`,`cond`,`description`,`variable`,`weight`,`spry_args`,`spry_error`,`help_text`)
VALUES
(5, 'admin_username', 'text', '<>', 'test', 'Site', NULL, NULL, '', 'Admin_Username', 72, '<2c20226e 6f6e6522 2c207b69 73526571 75697265 643a7472 75652c20 76616c69 64617465 4f6e3a5b 22626c75 72222c20 22636861 6e676522 5d7d>', NULL, '<54686973 20697320 74686520 41646d69 6e697374 72617469 76652055 7365726e 616d6520 74686174 2073686f 756c6420 62652072 65736572 76656420 666f7220 74686520 77656273 69746520 64657665 6c6f7065 722e204f 6e6c7920 74686973 20757365 72207769 6c6c2062 65206162 6c652074 6f206d6f 64696679 20746865 20646574 61696c73 206f6620 74686520 53657474 696e6773 20706167 652e2041 64646974 696f6e61 6c206164 6d696e69 73747261 74697665 20616363 6f756e74 73206361 6e206265 20637265 61746564 20756e64 65722074 68652027 55736572 73272073 65637469 6f6e206f 66207468 6520506f 77657243 4d532041 646d696e 202d2074 68657365 20757365 72732077 696c6c20 6e6f7420 62652061 626c6520 746f206d 6f646966 79207468 65736520 73657474 696e6773 2e>'),
(6, 'admin_password', 'text', '<>', '123', 'Site', NULL, NULL, '', 'Admin_Password', 73, NULL, NULL, NULL);




it will create them as, username: test. pass: 123

you can edit them after the records are created

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...