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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Getting MySQL errors on pages created with dataassist and upload file

Thread began 2/28/2011 7:00 am by mrs | Last modified 3/11/2011 11:42 am by mrs | 2052 views | 7 replies

mrs

Getting MySQL errors on pages created with dataassist and upload file

Hi, I have used site sculptor to build a site which has been up and running for a few years now, and I have been asked to add a few upload capabilities to the site.

So, I used data assist to create the pages, and then I used the file manipulation upload that came with css form builder to add upload capabilities to the insert and update pages, however, I am getting these errors:

On the insert page:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux133/g/website.com/user/htdocs/admin/headimages_Insert.php on line 42

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux133/g/website.com/user/htdocs/admin/headimages_Insert.php on line 46

Line 42 is: mysql_select_db($WA_connectionDB, $WA_connection);

Line 46 is: $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

What has me bemused is that both the upload and the database insert have worked, but the page still errors!


On the results page:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux133/g/website.com/user/htdocs/admin/headimages_Results.php on line 45

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux133/g/website.com/user/htdocs/admin/headimages_Results.php on line 48

Line 45 is: }

Line 48 is: mysql_select_db($database_localhost, $localhost);

With this page, there is nothing happening other than the data being called into the page... no inserts or uploads whatsoever


The trouble is, I can see the insert and results pages on my localhost, but I can only see the insert page on the remote server. The error on the insert page both locally and remotely is coming after I click upload.


IT GETS WORSE!!

It seems that as a result of upgrading to the latest versions of software (CSS form Builder and HTML editor 3) and then uploading the helper files and other includes that are used by data assist and file manipulation upload, a previous upload facility is no longer working... I constantly seem to be revisiting pages of sites that were previously working whenever I try to add new pages. This is frustrating for me as I m now getting a rollocking from my client!

I really need some guidance here. I have used data assist more times than I can remember, and I have used it successfully in the past with this particular site even though the site was initially created with site sculptor. I have also used file upload lots of times with little problem, and never before has it seemed to cause problems with previously built pages.

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