PageBuilder and MySQL Database

Heres the scenario...

I have a Dolphin Install on Hostforweb.com.  (I have also installed on my own apache server).  I have a MySQL database on my own local server (Windows Web Server Latest MySQL).

Everything works when it creates the tables, the records, etc.....  HOWEVER!  the Page builders do not work.

I can move elements around.  On or Off the Active page.  I cannot save them.  I cannot create a new HTML Block.

NOW, BEFORE ANYONE STARTS BLASTING 'USE FIREFOX, OPERA, GOOGLE, ETC', This is NOT a browser issue.  This is NOT a cache issue.   This is an issue where the either the TinyMCE editors, or the JavaScript files are not able to create the record. 

Most likely this is an issue on my MySQL server, but I dont know where to look.

Any other part of the Admin that directly access the Database works.  I can go into the Language files and modify any one of those and the changes are reflected on the database on my server.  Only the builders have this problem.  Fields builders, and Navigation builders also will not create a new element or save changes to an existing element.

And if I do Manually create the record in the database, It Does show up in the builders pages. 

Like I said, it very well could be my MySQL server, or may be inside one of the scripts.

Please Help if you can....

Steve Patino

IASCA Worldwide Inc.

I am having the very same problem, please can anyone help

@ TexasDragon

I'm trying to help nix1602 to solve this problem (this is probably a browser or a user issue as his builders are working fine for me both with IE7 and FF)... Maybe keep in touch with him. He will probably share the solution with you and translate my messages from french to english for you ;-)

I was really wanting to use the MySQL Server already setup on my Windows box. 

I originally tried to install Dolphin on the windows box, since I did install the PHP add-ons for it... but it still kept coming up with errors upon errors...   Thats when i decided to build a Linux box to host Dolphin, but still wanted to use the Windows box for MySQL... I have Coldfusion on the Windows box as well (My prefered SQL Scripting Language).  This way I could interact with the Dolphin DB in some of my own scripts that Im building...

My Solution ended up being this..... I installed MySQL on my Linux box.  Site works perfectly...  Now I need to find out if I can still use my ColdFusion on the Windows box with the MySQL on the Linux Box.

Check out How Im using Dolphin.

http://www.springbreaknationals.com

Thanks again to Michel for his invaluable help, I have not figured out yet what is the problem and still cannot access the builders on my PC, yet I was able to do so on a quite old laptop (??)

TD as Michel said if I can be of any help or if I can help with some translation, be delighted to do so, I will post the answer once I figured out what is the problem when and if I found it, for other

In alot of posts Ive read that new pages cannot be created, etc....  

So after having my own installs, and multiple ones at that, on many different servers, Ive been able to sorta pick it apart. The only thing I can come up with is that it as something to do with the fact that the JavaScript files that control the builder pages, somehow is not creating the record in the PageCompose Table (I think thats the right table) in the database...  The very second that an element is dropped in the builder pages, it creates that record.  So the JavaScript files that control the drag and drop/move/create part of the builder pages has to make the call to the database to create that record.  Ive had installs on HostForWeb and have not had a problem with it... Ive had installs on GoDaddy hosting, and did have problems. Then I had an install on HostForWeb, but tried to use the Database on my own server.  Now theres a problem.. and then I tried it the exact opposite, Host the site on my server, but have the Database on HostForWeb..  That did not work, since I was unable to add my IP address to the MySQL access list.

Since on HostForWeb, the site and the Database are considered to be localhost to that server, meaning the website and the database are on the same IP address, it seems to work... Take that one step further, Setup my own Linux/Apache/MySQL server and host both the site and the database on the same box... it worked...   

Only when the Database and the Site files were on different IP's were their problems...  Maybe the Javascript files werent reading the inc/header files correctly...  Thats where I got stumped....

Put both site and database on the same IP.  If hosted, make sure in your MyPHPAdmin, that the database says localhost, and not some wierd IP address.  Give that a try....

Steve