close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Database not appearing in database panel

Thread began 4/14/2020 2:21 pm by Paul | Last modified 4/22/2020 3:25 pm by Ray Borduin | 63 views | 11 replies |

PaulBeta Tester

Database not appearing in database panel

I have created pages using the datassist tool.
I defined a database in the tool.

All pages create ok, however whilst the connection page appears in the connection folder, it does not appear in the database panel.
This also crashes the results page when I execute a search;

Warning: strpos(): Empty needle in /Applications/XAMPP/xamppfiles/htdocs/web/Kb4/Connections/nihCONN3.php on line 15

Warning: require_once(../Connections/.php): failed to open stream: No such file or directory in /Applications/XAMPP/xamppfiles/htdocs/web/Kb4/apps/TACdb1_results.php on line 2

Fatal error: require_once(): Failed opening required '../Connections/.php' (include_path='.:/Applications/XAMPP/xamppfiles/lib/php') in /Applications/XAMPP/xamppfiles/htdocs/web/Kb4/apps/TACdb1_results.php on line 2

Any thoughts please?

Sign in to reply to this post

Ray BorduinWebAssist

It looks like you have an unnamed connection? It is looking for a connection named:
Connections/.php

Maybe you didn't have a connection selected when you ran the wizard somehow?

Sign in to reply to this post
Did this help? Tips are appreciated...

PaulBeta Tester

So, if I create a DB connection using the WA Database panel, ie clicking the '+' to open the database connection type wizard - it opens fine.
I enter all parameters and pick my database in localhost.

When I ok it, nothing appears in the WA Database panel!

Only the connection folder.

Refreshing the panel has no effect.

The connection is visible and a selectable option when I run the DA wizard.

As you can see I've made a few attempts now!

Sign in to reply to this post

Ray BorduinWebAssist

I can do screen sharing with you to look into it. If you export your site definition I might be able to download your connections and reproduce it that way. I think the easiest path to a solution is to send me your phone number and we can do screen sharing to investigate what might be causing the problem.

Sign in to reply to this post
Did this help? Tips are appreciated...

PaulBeta Tester

Thanks Ray. However I've managed to unpick all but one remaining issue which is still being thrown on the results and selected item update page.

Warning: strpos(): Empty needle in /Applications/XAMPP/xamppfiles/htdocs/web/Kb4/Connections/nihCONN3.php on line 15

The routine which commences line 15 is as follows;


if (strpos(strtolower($_SERVER["SERVER_NAME"]),strtolower($domainCheck)) !== false && ($domainCheck == "" || strpos(strtolower($_SERVER["SERVER_NAME"]),strtolower($domainCheck)) == strlen($_SERVER["SERVER_NAME"])-strlen($domainCheck))) {
$hostname_nihCONN3 = "192.168.100.3";
$database_nihCONN3 = "****";
$username_nihCONN3 = "****";
$password_nihCONN3 = "****";
$foundConnection = true;
}

Im ftp 'ing the live site to my nas IP.

Sign in to reply to this post

Ray BorduinWebAssist

It looks like $_SERVER["SERVER_NAME"] is not defined on your server. Which is odd. It implies a server configuration issue of some sort. Are you using a dynamic connection, or do you test on your live server? That code is used to identify the server the code is running on and change the connection based on the server name. You could try setting the value programmatically or deleting that IF statement to get around the issue, or talk to your hosting provider to see if they can update the server so that it is properly defined.

Sign in to reply to this post
Did this help? Tips are appreciated...

PaulBeta Tester

I'm using a connection to localhost on my machine and a second dynamic pointing to the server and phpmyadmin on my nas

I've just noticed that all Connections I've created are listed in the WA Database panel, but the filenames are (invisible) transparent or same color as background.

If I hover over where the list would appear, the mouse pointer changes allowing me to select them.

This is not expected behaviour.

I'm going to try a reinstall of everything.

Sign in to reply to this post

Ray BorduinWebAssist

That is probably an issue with our panel when a specific color scheme is used in Dreamweaver. I'll play with it and see if I can figure it out. I probably have to update it to override the color scheme settings in Dreamweaver so it will always look right.

I wouldn't reinstall... just update your color scheme. Go to Edit->Preferences and choose "Interface" in the left-hand column. Then choose a dark theme and I think that will fix the issue.

Actually I can't seem to find a theme that updates the color of that text. I'm not sure what might control it. Let me know if you figure it out. If I can reproduce it then I can fix it.

Sign in to reply to this post
Did this help? Tips are appreciated...

PaulBeta Tester

Ok, so yeah, non of the default coloraturas schemes have an impact.
What I did notice is that if I remove the DB panel then add it again by dragging to an edge so that it fills top to bottom, as opposed to the smaller panel in the side bar, if I then slowly remove it from its 'snapped' position the background color changes briefly from its default white to a dark blue background, thus revealing the listed db connections. Unfortunately and unexpectedly during that brief manouevre the background color returns to white again and the db connections become 'invisible' again.

If the panel background can be stabilised to a darker color or the db connection icons can be darkened, we are back in business.

Sign in to reply to this post

Ray BorduinWebAssist

I can work with you on this in a screen sharing session. I'm unable to reproduce it on my end, but if you give me your phone number and a good time to reach you then I can call and work on it with you directly to find a good solution.

Sign in to reply to this post
Did this help? Tips are appreciated...
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...