close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Vanilla PS2 database error

Thread began 2/10/2010 10:14 pm by bsteve2004309526 | Last modified 2/11/2010 8:26 pm by Eric Mittman | 588 views | 1 replies |

bsteve2004309526

Vanilla PS2 database error

I am new to PowerStore 2 so please bear with me on this question.

I created a vanilla PowerStore2 environment on my PC which will be used to see how the system "should" work for when I start modifying the code for our commercial store. This is the first PS2 store I have created.

MY CONFIGURATION and SETTINGS:
Using DW4, XAMPP 1.73, MySQL 5.3.1 under Windows 7.

Path to the PS2 files on my localhost is C:\xampp\htdocs\PowerStore2NoUpdates. All PS2 files are stored under the PowerStore2NoUpdates folder.

localhost.php file looks like this:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_PowerStore2NoUpdates = "localhost";
$database_PowerStore2NoUpdates = "psvanilladb";
$username_PowerStore2NoUpdates = "stevnmburns";
$password_PowerStore2NoUpdates = "XXXXXXXXXX";
$PowerStore2NoUpdates = mysql_pconnect($hostname_PowerStore2NoUpdates, $username_PowerStore2NoUpdates, $password_PowerStore2NoUpdates) or trigger_error(mysql_error(),E_USER_ERROR);
?>

I can successfully test the DB connection from within DW.

WA_Globals.php looks like this;
<?php
$WAGLOBAL_Root_URL = "http://localhost/htdocs/PowerStore2NoUpdates/" ;
...
$WAGLOBAL_localRoot = "/PowerStore2NoUpdates/";
$WAGLOBAL_remoteRoot = "/";

From an IE browser, when I enter "localhost" I get a redirected URL of xampp/ and I see the XAMPP congrats screen.


MY ERROR:
From within DW if I click on Live Code from the Index.php I see only the first third of the index page and I get the following two messages:
<b>Warning</b>: session_start() [<a href="function.session-start">function.session-start</a>]: Cannot send session cookie - headers already sent by (output started at C:\xampp\htdocs\PowerStore2NoUpdates\index.php:3) in <b>C:\xampp\htdocs\PowerStore2NoUpdates\WA_eCart\WA_eCart_Definition_PHP.php</b> on line <b>479</b><br>
<br>
<b>Warning</b>: session_start() [<a href="function.session-start">function.session-start</a>]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\PowerStore2NoUpdates\index.php:3) in <b>C:\xampp\htdocs\PowerStore2NoUpdates\WA_eCart\WA_eCart_Definition_PHP.php</b> on line <b>479</b><br>

Finally, if I try to view the index.php via IE I again see only the top third of the page and I get the following messages:
Warning: mysql_select_db() expects parameter 2 to be resource, null given in C:\xampp\htdocs\PowerStore2NoUpdates\CSSMenuWriter\cssmw_home\menu.php on line 58

Warning: mysql_query() expects parameter 2 to be resource, null given in C:\xampp\htdocs\PowerStore2NoUpdates\CSSMenuWriter\cssmw_home\menu.php on line 60

I believe the answer is in my configurations as I am able to see the first third of the index page but the code seems to die when trying to determine the DB it should be connecting to in order to display the rest of the page.

Sign in to reply to this post

Eric Mittman

How do you have your testing server defined in DW? Also, what is on your index page on line 3? There may be an extra space near this line or it could be referring to an mysql error that is occurring.

As a test you can create a new php page and add a recordset to the page. After you add in the recordset you should go to the bindings tab and drag a couple of bindings from the rs onto the page then preview it in the browser.

Sign in to reply to this post

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