Error Message - Won't Start

[esms]

Earlier today, I had this problem with SITE IMPORT: http://www.webassist.com/forums/showthread.php?t=5181

I deleted the wincache file as advised and SI now works.

But, now I'm having a similar problem with CSS Sculptor 3 - see screen shot.

Do I have to delete the wincache file each time I use WA?

Powerstore and PowerCMS didn't work for me in that I believed they would run 'out of the box' as indicated.

It's getting to the point where I dread having to use all the ironically named Web Assist products I've bought; i.e. pretty much all of them!

[Jason Byrnes]

Any time you install a new extesnion, you should delete the Dreamweaver cache file to keep these errors from occurring.



What is the problem you are having with PowerStore and PowerCMS?

Have you gone through the getting started guides for them to complete the needed configurations?

[esms]

I unzipped the Powerstore file and uploaded to my hosting provider but all I see is:

edited !

[Jason Byrnes]

Before you can upload and use the PowerStore or PowerCMS files, there are a few edits that need to be made to the WA_Globals/WA_Globals.php file and the Connections/localhost.php file. These edits are necassary to gather inforemation that is unique to your server.

In the Connections/localhost.php file you must specify the address for you MySQL Server, the username and password to connect and the database that you have added the necessary tables to.


Please refer to the Getting Started guides for Power Store on Power CMS for instructions on what must be done to get them running, The getting started guides are available in the Getting Started Section of the Support pages for those products:

http://www.webassist.com/support/powerstore/
http://www.webassist.com/support/powercms/


For the error you are getting, see "How to update the database connection file" section:

http://assets.webassist.com/how-tos/sp_db_connection.pdf

[esms]

When I browse to the site it states: Warning: mysql_pconnect() [function.mysql-pconnect]: Unknown MySQL server host 'Please type your database hostname' (1) in /websites/123reg/LinuxPackage21/ti/ck/tr/ticktraining.co.uk/public_html/Connections/localhost.php on line 9

Fatal error: Unknown MySQL server host 'Please type your database hostname' (1) in /websites/123reg/LinuxPackage21/ti/ck/tr/ticktraining.co.uk/public_html/Connections/localhost.php on line 9


I've looked at line 9 of localhost.php that came with the program and I see this: $localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);


Is this correct?

[Jason Byrnes]

You have not made any changes to the connection file to add the correct MySQL Host name, username, password or database, please see the following for instructions:
http://assets.webassist.com/how-tos/sp_db_connection.pdf


until you have modified the Database connection file, it will not work.

[esms]

Hello,

Perhaps it's my fault for automatically believing the 'Powerstore' advert movie on the WA main website whereby it states you'll have the store running in NO TIME at all without the need to learn any PHP.

Assuming my copy of 'Powestore' wasn't corrupted when downloading, I've had a look at these forums and noticed that some people have managed to get it running albeit after much confusion.

This is what I've had to do so far. I followed the instruction in powerstore2_gsg.pdf whereby it initially states:

1. Set up your MySQL database. A .sql script containing the required database tables, has been provided for you to use with this Solution Pack. Click the link for instructions on importing this file into your MySQL database. http://www.webassist.com/go/howto/import_sql

2. I followed the instructions in the importing_sql.pdf. They state the following:

1. On your computer, navigate to the .sql file you intend to import to your database. 2. Open the .sql file in a regular text editor such as Notepad or TextEdit.
3. Select all the content by pressing Ctrl (Cmd) + A. 4. Copy the content by pressing Ctrl (Cmd) + C. 5. Close your text editor application. Executing the script. 6.
In phpMyAdmin, choose the database you intend to work with from the Database menu list. 1. Choose the SQL tab. 2. Paste the SQL script you copied by pressing Ctrl (Cmd) + V
3. Choose Go. 4. Confirm that your new table has been imported by clicking the Structure tab.



I then moved back to the first pdf document whereby I now followed the instruction to open another pdf document: sp_db_connection.pdf

Here, I followed the instructions to:

'1. Enter your MySQL server host name within the quotations of the following line. $hostname_connection = " "; 2. Enter the name of your database within the quotations of the following line. $database_localhost = " "; 3. Enter the username for accessing your MySQL server within the quotations shown here. $username_localhost = " "; 4. Enter the password for accessing your MySQL server within the quotations shown here. $password_localhost= " "; 5. Save the file by pressing Ctrl (Cmd)+ S.



Once done, I moved back to the first pdf document again where I am instructed to open a third pdf document (sp_ps_globals_2.pdf) of 13 pages in length so that I can change further settings. This done, I read through the fourth and fifth pdf documents so that I can alter the look of the first page of the store and upload to the server.


I haven't gone on to PDF document number six yet because I seem to be getting errors on some of the pages.

For example, the drop down menu on the home page doesn't display properly for the bottom link. Also, if I click on the 4th link (About Tick), I get the following error: Fatal error: Call to undefined function getsqlvaluestring() in /websites/123reg/LinuxPackage21/ti/ck/tr/ticktraining.co.uk/public_html/CSSMenuWriter/intermediate.php on line 22. additionally, on the Contact Us link I get 'Fatal error: Call to undefined function getsqlvaluestring() in /websites/123reg/LinuxPackage21/ti/ck/tr/ticktraining.co.uk/public_html/CSSMenuWriter/intermediate.php on line 22'



I've no idea why this has happened. Is it possible I might have a corrupted copy of PS2 when I download it?

I'm guessing if I download it again and run this whole procedure again I might have better luck. I'll let you know how I get on.


The link to the site is www.ticktraining.co.uk It's not a real company, it's just something I set up to see if PS2 was going to work for me.

[Jason Byrnes]

my appologies, there seams to be a bug in the CSSMenuWriter/intermediate.php file.


open the CSSMenuWriter/intermediate.php file, and paste the following code at line 1:
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

?>

[esms]

Hello.

Yes. Thank you. This extra code has fixed the google maps problem.

Do you know if this extra required code is specific to my version of PS2, or is it required for all?

I ask in case others can't get their copies of PS2 to work, and it might be worth making it avaiable to all.

Thanks.

[Jason Byrnes]

It appears to be a bug for all. I have logged this in our bug base to have it addressed for future versions.