Stack Overflow
Stack Overflow

Questions tagged [cleardb]

ClearDB is a reliable, fault tolerant database-as-a-service for MySQL. It is also a heroku addon for mysql databases

ClearDB is a heroku addon for managing databases.

More info here: https://devcenter.heroku.com/articles/cleardb

247 questions
1
vote
0 answers

How do you deploy a form linked with PHP to a MySQL Database to Heroku

Long story short I have a form made in HTML/CSS that is being processed with PHP to populate a MySQL Database. We then have another form that is going to be used as a search for the same DB which will then show a search results page. How do we…
mcclaskiem
  • 394
  • 1
  • 15
1
vote
1 answer

PHP PDO Error while executing and inserting in cleardb

Hi I am getting error during the execution of PDO prepare statement. My local development works fine but when I try to insert to cleardb in cloud this error occur: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to…
surajnew55
  • 573
  • 1
  • 11
  • 25
1
vote
2 answers

Problems setting up Grails 2.3.5 App on Heroku with ClearDB

I am setting up a Grails 2.3.5 App on a Heroku Server and I keep getting the following error when tomcat starts up: Caused by: java.sql.SQLException: Driver:com.mysql.jdbc.Driver@5a7359fe returned null for…
winna
  • 539
  • 1
  • 3
  • 16
0
votes
1 answer

Connecting to Heroku ClearDB MySQL database gives me "positional arguments" error

I just created a Python/Django project with a MySQL database that I am trying to host on Heroku. I added a ClearDB database to my Heroku project, but when I try to migrate my database, it gives me this error: DatabaseWrapper.display_name() takes 0…
Ian McInnes
  • 21
  • 2
0
votes
0 answers

Cannot load local infile to mysql workbench

When trying to upload a local file into an existing table using mysql workbench (that is hosted through keroku clearDB), I am receiving the following error: "Error Code: 1148. The used command is not allowed with this MySQL version" load data…
fugazzi
  • 17
  • 2
0
votes
0 answers

INSERT INTO for PHP is not inserting data into my database users table

INSERT INTO for PHP is not inserting data into my database users table on MySQL workbench. When click the submit button it just goes to a blank submit.php file when it's suppose to redirect to the login page once a user finishes inputting their…
A Knight
  • 1
  • 1
0
votes
0 answers

Why is code still being executed in a production environment that has been completely erased from the code base?

I have a website hosted on Heroku. There's currently only 3 active apps. A very old Review App that never had this specific code, Staging, and Master. The code is in a setInterval that every like 16 hours or so it grabs a specific set of users from…
Bryan
  • 1
  • 2
0
votes
0 answers

Impossible to connect to a mysql Cleardb database on Heroku

My last build failed with this error message: Executing script cache:clear [KO] [KO] Script cache:clear returned with error code 255 !! !! In ExceptionConverter.php line 117: !! …
eric
  • 11
  • 2
0
votes
0 answers

Server Status showing way too many queries and questions increasing per second on MySQL ClearDB

I have a MySQL DB (ClearDB) serving my backend application hosted on Heroku. That said I have very limited ways to actually see the logs (no access to the logs apparently) to even know what these queries are. I know for sure nobody is using the…
Rafael Santos
  • 293
  • 3
  • 18
0
votes
0 answers

Connectin Clear Db in heroku application with mysql.connector

I am trying to connect to ClearDb with Heroku from python app I use mysql.connector My code look like this: conn = mysql.connector.connect( host="clearDbHost", user="123qwe", password="123qwe", …
Mike Hadzhiev
  • 27
  • 6
0
votes
1 answer

Can't connect to ClearDB database after resetting password

I am trying to deploy a very simple nodejs api through Heroku and utilizing the clearDB add on so I can connect to the MySQL db the api utilizes. I had everything connected and working then realized I had hard coded and exposed the database user and…
Jason Thuma
  • 15
  • 6
0
votes
1 answer

An error was encountered when contacting the add-on partner to create cleardb:ignite

I deployed my application in Heroku approximately one month ago and I deployed with ClearDB and I also use MySQL Workbench. There is no problem in ClearDB before but since last week, I have reached max_question and max_user limit exceeds and today,…
İpek Oktay
  • 1
0
votes
0 answers

SQL Query not Giving a Result

I am trying to login my user and i need to search whether the user exists in the db or not. My db is ClearDB using MySQL on Heroku. I am using node.js. This is my code: if (req.body.isAdmin === 1) { connection.query( `SELECT * FROM…
Mushood Hanif
  • 501
  • 1
  • 5
  • 17
0
votes
1 answer

mysql is not valid at this position expecting eof

SELECT ref, Sum(transactions.amount) OVER( ORDER BY id) FROM transactions localhost mysql phpmyadmin runs the code with no problems. However when uploading to heroku ClearDB "mysql is not valid at this position…
Chathura N Kodikara
  • 1
0
votes
1 answer

Lost connection to MySQL on heroku with ClearDB

I've deployed a form website which can insert the user's input to the MySQL database onto heroku with ClearDB. But when I submit the form, I either get the error [2055 Lost connection to MySQL server] or [2013: Lost connection to MySQL server during…
Weber Chang
  • 45
  • 1
  • 7
1 2 3
…
16 17