close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Error Message - Won't Start

Thread began 10/06/2009 6:22 pm by mstruthers9080 | Last modified 10/14/2009 2:47 pm by Jason Byrnes | 2690 views | 9 replies |

mstruthers9080Beta Tester

Error Message - Won't Start

Earlier today, I had this problem with SITE IMPORT: 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!

Sign in to reply to this post

Jason ByrnesWebAssist

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?

Sign in to reply to this post

mstruthers9080Beta Tester

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

edited !

Sign in to reply to this post

Jason ByrnesWebAssist

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:

powerstore/
powercms/


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

sp_db_connection.pdf

Sign in to reply to this post

mstruthers9080Beta Tester

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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:
sp_db_connection.pdf


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

Sign in to reply to this post

mstruthers9080Beta Tester

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. 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.

Sign in to reply to this post

Jason ByrnesWebAssist

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:
<?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;
}
}

?>
Sign in to reply to this post

esmsBeta Tester

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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

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...