20 questions
1
vote
1
answer
233
views
Cannot Login sqlbuddy on Ubuntu localhost
I installed lamp server into my Ubuntu 16.04 via tasksel. After then I downloaded sqlbuddy and set it up to /var/www/html.
I called following link (localhost/sqlbuddy) that appeared SqlBuddy Login ...
2
votes
1
answer
2k
views
Sqlbuddy login not working with PHP 7.0
I have searched for an answer to this, but haven't found anything. I was wondering if anyone had come across the same issue and had any insight. I have PHP 7.0 installed on an nginx web server with ...
1
vote
1
answer
736
views
Completely exlude subdomain with Varnish
Scenario:
I have an Apache/Varnish setup with a number of different subdomains. Every subdomain has its own VirtualHost-file in sites-enabled but all run in the same Wordpress installation. Except for ...
0
votes
1
answer
113
views
Resolve Javascript Conflicts / jquery
I am trying to add jQuery to the PHP of SQLBuddy and am getting some conflicts. If I just include jQuery, the rest of the program stops functioning and doesn't pull the tables / databases.
If I use ...
0
votes
1
answer
1k
views
Editing user permissions or restoring SQLBuddy to default, for Wampserver?
I accidentally locked myself out by creating a new user account (with what I thought had full privileges) and deleting root altogether instead of editing it. I'm not the brightest bulb in the box ...
0
votes
1
answer
103
views
SQL statement in php will not insert onto database
I have this SQL statement that i'm trying to get to save new students to a table of students, however it simply isn't doing it, I don't get any error messages when I run error reporting and I ran the ...
1
vote
0
answers
509
views
PHP Errors when Accessing Sqlbuddy
As a bit of a side project, I've been following a guide on how to set up an Nginx web server from here:
http://arstechnica.com/information-technology/2012/12/web-served-part-4-get-your-database-on/2/
...
1
vote
0
answers
292
views
Sqlbuddy show very slow responsetimes
i don't know if this is the right place to ask a question but i'm going to try anyway...
I was looking for a leightweight alternative of phpmyadmin and found sqlbuddy. Very good performance at first ...
0
votes
2
answers
947
views
Cannot access sqlbuddy on nginx server
I installed sqlbuddy following the guide by arstechnia, but I cannot seem to access sqlbuddy.
This is the setup for /etc/nginx/sites-available/www
server {
listen 80 default_server;
...
0
votes
0
answers
364
views
Does phpMyAdmin SQL command differ from sqlbuddy?
I'm learning php/mysql, I have made a php page and I have a form on a host that has a sqlbuddy database, when I ws a adding a column in the table but the I got this:
You have an error in your SQL ...
0
votes
1
answer
245
views
SQL Buddy , mySQL Error for LOAD DATA LOCAL INFILE
I am trying to import a CSV file into mysql database. but the query is giving error. The query is :
LOAD DATA LOCAL INFILE ‘/last.csv’ INTO TABLE punjab FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES ...
0
votes
1
answer
458
views
Creating a password for the mysql root account has caused problems in WAMP
I have created a new password for the root account using:
mysqladmin -u root password "[newpassword]"
This caused problems with connecting to phpmyadmin which I solved by changing the config.inc....
4
votes
1
answer
2k
views
SQL Buddy Export to file "The file could not be opened"
I installed SQL Buddy on my localhost and it has worked really well in place of phpMyAdmin, but the one thing I'm having issue with is when I need to export a database and choose to export as a file (...
0
votes
1
answer
2k
views
sqlBuddy doesn't accept this .sql file to import
I would like to know why is this: backup.sql file not being accepted by sqlBuddy, I already created a database named youhand with utf8
sqlBuddy message:
0 statements were executed from the file.
...
0
votes
1
answer
1k
views
sQl buddy: you have an error in your SQL syntax;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'charset utf8 not null auto_increment index key, toId int(11) ...