failed to execute query associated...
Hello
I have got this error using last nights builld of form builder on mac osx server with mysql installed and running
sequel server pro is reporting the connection is ok to WF_FORM and i have the user setup there with the rights to do anything. There is no tables in the database. I am able to reduce the error to just this by making the web server folder containing the html index file and export subfolder (without the -exported) read and write do you know if that Is secure?
also is the reference to "save_SQLlite" in the config file is that correct? I made the form using lite but bought the full version and used the same form
The config file is thus
{
"database" : "WF_FORM",
"is_present" : true,
"password" : "xxxxxxx",
"port" : 3306,
"server" : "localhost",
"tablename" : "form-results",
"username" : "wform"
},
"save_file" :
{
"filename" : "form-results.csv",
"is_present" : false
},
"save_sqlite" :
{
"database" : "WF_HOURS.dat",
"is_present" : false,
"tablename" : "WF_HOURS"
}
I have got this error using last nights builld of form builder on mac osx server with mysql installed and running
sequel server pro is reporting the connection is ok to WF_FORM and i have the user setup there with the rights to do anything. There is no tables in the database. I am able to reduce the error to just this by making the web server folder containing the html index file and export subfolder (without the -exported) read and write do you know if that Is secure?
also is the reference to "save_SQLlite" in the config file is that correct? I made the form using lite but bought the full version and used the same form
The config file is thus
{
"database" : "WF_FORM",
"is_present" : true,
"password" : "xxxxxxx",
"port" : 3306,
"server" : "localhost",
"tablename" : "form-results",
"username" : "wform"
},
"save_file" :
{
"filename" : "form-results.csv",
"is_present" : false
},
"save_sqlite" :
{
"database" : "WF_HOURS.dat",
"is_present" : false,
"tablename" : "WF_HOURS"
}
Further to my last the problem seems to be that it is not writing the database files into the storage folder is this because it cannot access the sql server first?
Does the storage folder exist?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Hi Eric
Sorry for delay
Yes as per attached
php log file also
Sorry for delay
Yes as per attached
php log file also
Check your permissions for the storage folder.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Hi Eric
I am in a whole world of pain with MySQL i just cannot get it to run now on my server.... not wanting to spend anymore time on that... I just don't have the unix skills
Can you recommend using another app or service with form builder to store data in a much simpler way?
I would be happy if i could just get the form to update a spreadsheet in real time
I really just want to build some basic statistics not run full on business app with sql queries etc
Thanks
I am in a whole world of pain with MySQL i just cannot get it to run now on my server.... not wanting to spend anymore time on that... I just don't have the unix skills
Can you recommend using another app or service with form builder to store data in a much simpler way?
I would be happy if i could just get the form to update a spreadsheet in real time
I really just want to build some basic statistics not run full on business app with sql queries etc
Thanks
I use mysql myself but you could generate a csv and bring that into Excel.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.