33 Topics
 | |
| | Basic background information Mariadb Ver 15.1 District 10.11.6 MariaDB Glarea cluster, one with three nodes: Node1:192.168.18.78 Node2: 192.168.18.79 Node3: 192.168.18.80 Among them, Node1 node was restarted after a power outage of 1 hour, and after executing the system ctl start mariadb, it was stuck for a long time (running for … |
| | > $amtpaid = is decimal 530.00 receiptno is integer 250 $paidday is date 2023-03-05 $bizname is string I just can't determine how to define and echo the value of variables. <!DOCTYPE html><html> <head> <title>record payment</title> <html><head> <script type="text/javascript"> var monthNames = [ "January","February","March","April","May","June","July", "August","September","October","November","December" ]; var today = new Date(); … |
 | I am trying to insert the current `time()` and `$_SERVER['REMOTE_ADDR'];` into my database I have this code <?php require_once("../core/core.php"); $user_time = time(); $ip = $_SERVER['REMOTE_ADDR']; $sql = "SELECT * FROM userinfo WHERE ip = $ip"; $result = $conn->query($sql); if(!$result) { trigger_error('Wrong SQL: ' . $sql . ' Error: ' . … |
 | i am running ubuntu 22.04 and php 8.1 / MariaDB , i am missing somthing here in my code just can't see it. the premise of the code is to look at the TrolleyID Field and if it's '00000' basically echo's "BAD-READ" else it's 'GOOD-READ' any help would be great …  |
| | hello, im developing a Windows application with MariaDB database for criminals, i designed the whole database schema but i need an expert to help me study it if it is mall designed. |
| | Hi. I got some problem. I want to search data from 2 tables in database and display the result based on the search value. For example, I search employee id number, it will search the employee id number in table 1 and table 2. If the data exist in either …  |
 | |
| | I am trying to establish a connection between LibreOffice (5.4.6.2) and Mariadb (10.1.29)/mysql. I have researched various resources on the web but am stuck not being able to establish a connection preliminary steps taken: * the file mariadb-java-client-2.4.0.jar is downloaded from [https://downloads.mariadb.com/Connectors/java/connector-java-2.3.0/](https://downloads.mariadb.com/Connectors/java/connector-java-2.3.0/) * JRE is installed and enabled under LibreOffice … |
 | Hello i am getting an error on a CASE WHEN THEN syntax on my mySql SELECT DISTINCT u.uid,c.c_id,u.name,u.profile_pic,u.username,u.email,c.time FROM conversation c, users u, conversation_reply r CASE WHEN c.user_one = '99' THEN c.user_two = u.uid WHEN c.user_two = '99' THEN c.user_one= u.uid END AND ( c.user_one ='99' OR c.user_two ='99' ) … |
| | Hi, I am using node and refactoring an older database. Therefore, i want to ensure i incorporate correct practices from the start. I know that this is a debated topic and that there is not nessecarily a correct answer but i want to see what people have to say about … |
 | Hello, I hope not to scare you with this long post. I'm testing [Solr](https://lucene.apache.org/solr/) (read solar) and it works fine. I have an issue with the **DataImport** handler, it's set to get data from a MariaDB database, which works fine if I save the database credentials in plain text in …  |
| | I got a syntax error flag in my "users" database table, but can't figure the issue out. Please, I need your help. The following is the error message: Error SQL query: --------------------------------------------------------- -- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT( … |
 | Hello, I am trying to rename database MySQL: RENAME DATABASE old_db_name TO new_db_name; 1 kesalahan ditemukan dalam analisis. A rename operation was expected. (near "" at position 0) Query SQL: RENAME DATABASE wwwsoulf_revsoul TO wwwsoulf_revsoul2 MySQL menyatakan: Dokumentasi #1064 - You have an error in your SQL syntax; check the … |
| | Hello, so, I'm playing a bit with **MariaDB 10.0.29** and I cannot understand why `FOUND_ROWS()` keeps returning the `1` whatever happens to the latest select query. Here's my test: > CREATE TABLE `test` (`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `msg` VARCHAR(100) NULL) ENGINE = InnoDB; Query OK, 0 rows affected … |
 | I'm trying to reset my mariadb password following this site -> https://www.rosehosting.com/blog/how-to-reset-your-mariadb-root-password/ but when I enter `mysql -u root` I get the following error: `ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")` Any ideas? Thanks. |
| | File drop database if exists contacts create database contacts; use contacts; create table names ( ID mediumint not null auto_increment primary key, firstName varchar(20), lastName varchar(20) ); create table addresses ( ID mediumint not null auto_increment primary key, nameID mediumint not null, addr1 varchar(30), addr2 varchar(30), city varchar(30), state varchar(10), … |
 | `INSERT INTO 'members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')` - `#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')' at line 1` |
| | Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting `SQLSTATE[HY2000][2002] Connection was activily refused...` I fixed that error by forwarding the port through the … |
| | I get the following in my web browser when I try to connect to my mariaDB database. `Error!: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)` It also doesn't matter if I use mariaDB root or a regular users credentials, I get the same thing. The error above … |
| | I'm working on a small web project (MariaDB LAMP stack) on my desktop but I'd like to be able to continue working on the project when I am away from home computer. I think I can sync my /var/www/html/ directory without a problem but does how can I export my … |
| | The program below is just a simple test to see if I can get it to fetch the correct data from MariaDB and then display it on the screen but so far I'm not having any luck. I left the action attribute's value blank because I want the PHP form … |
| | I'm working with MariaDB through PHPMyAdmin and I have a question about how I need to set up my database. For eash person in the table I am currently building I'll also need an array of date values. I don't think there is a way for me to setup a … |
| | When I try to create a database with a non root user of MySQL I get this error. -> MariaDB [(none)]> create database cl_db; -> ERROR 1044 (42000): Access denied for user 'garrett'@'localhost' to database 'cl_db' How do I allow my recular username to create databases? Thanks. |
| | I have the following code: <?php $fieldsClause = array(); $bindArray = array(); $fields = array('status','fname','middle','lname','address','city','state','zip','county','mailing','hphone','mphone','wphone','ext','fax','email','ethgroup','other1','occupation','poe','dob','gender','bhv','mrc','general','evv','allCounties','fillmore','johnson','otoe','richardson','seward','butler','gage','lancaster','pawnee','saline','thayer','cass','jefferspm','nemaha','polk','saunders','york','other2','aro','clergy','intskills','bus','child','law','cpr','data','security','emergency','computer','mechanical','administration','firstaid','translation','construction','basicclean','foodprep','animalcare','heavy','dataentry','identification','phone','runner','greeter','interviewer','safety','other2','interpt','cdl','cpryn','translate','other3','license1','verf1','num1','exp1','license2','verf2','num2','exp2','license3','verf3','num3','exp3','license4','verf4','num4','exp4','license5','verf5','num5','exp5','lsrd','syes','bcert','pauth','dist1','tdate1','dist2','tdate2','dist3','tdate3','dist4','tdate4','dist5','tdate5','felony','felonys','ename','erelation','ehphone','eaddress','ecity','ezip','hdyhau','bdesc','record'); foreach($fields as $field){ if($san = filter_input(INPUT_POST, $field, FILTER_SANITIZE_STRING)) { $fieldClause[] = "`$field` = :$field"; $bindArray[":field"] = $san; } } $sql = "INSERT INTO volunDB("; if (!empty($fieldClause)) $sqlF = implode(', ', $fieldClause); $stmtString = $sql; if(isset($sqlF)) … |
| | I have the following code: <?php $fieldsClause = array(); $bindArray = array(); $fields = array('status','fname','middle','lname','address','city','state','zip','county','mailing','hphone','mphone','wphone','ext','fax','email','ethgroup','other1','occupation','poe','dob','gender','bhv','mrc','general','evv','allCounties','fillmore','johnson','otoe','richardson','seward','butler','gage','lancaster','pawnee','saline','thayer','cass','jefferspm','nemaha','polk','saunders','york','other2','aro','clergy','intskills','bus','child','law','cpr','data','security','emergency','computer','mechanical','administration','firstaid','translation','construction','basicclean','foodprep','animalcare','heavy','dataentry','identification','phone','runner','greeter','interviewer','safety','other2','interpt','cdl','cpryn','translate','other3','license1','verf1','num1','exp1','license2','verf2','num2','exp2','license3','verf3','num3','exp3','license4','verf4','num4','exp4','license5','verf5','num5','exp5','lsrd','syes','bcert','pauth','dist1','tdate1','dist2','tdate2','dist3','tdate3','dist4','tdate4','dist5','tdate5','felony','felonys','ename','erelation','ehphone','eaddress','ecity','ezip','hdyhau','bdesc','record'); foreach($fields as $field){ if($san = filter_input(INPUT_POST, $field, FILTER_SANITIZE_STRING)) { $fieldClause[] = "`$field` = :$field"; $bindArray[":field"] = $san; } } $sql = "INSERT INTO volunDB("; if (!empty($fieldClause)) $sqlF = implode(', ', $fieldClause); $stmtString = $sql; if(isset($sqlF)) … |
| | I had this working earlier but had to tweak the code for some function that will be preformed later on but now I can't get the data to upload to the SQL server. I get error: PDOStatement::errorInfo(): Array ( [0] => 42000 [1] => 1064 [2] => You have an …  |
| | Eariler I wrote this topic: http://www.daniweb.com/web-development/php/threads/482142/searching-using-optional-parameters and I got ideas and got to this point with help of another guy: <?php $whereClause = "WHERE "; foreach($_POST as $k => $v ){ if( $v != "" ){ $whereClause = $whereClause . $k . "='" . $v . "' AND "; } … |
| | Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) … |
| | Hi All, I am new to use of database in Java. I am trying to write a simple java application which connects to my Database and sends some query and retrieves the output. I have downloaded MariaDB and then created a database named iff and created tablespaces which has some … |
 | Hello everyone. I hope you can help me with my problem. So here is the problem: I cant install mariadb5.5win32 on my laptop, (but my other classmates have already installed it on their laptops). I am the only one who can't install it. On the starting process of installing it, …  |
| | Hi, I am attempting to replace the database in an application with MariaDB. This application is written in C# and previously accessed the database (mostly inserts) with LINQ. When I attempt to insert (other transactions have the same type of issue) I get the error message: "You have an error … |
 | [URL="http://www.mysql.com"]MySQL[/URL] users listened intently Tuesday, April 13 at O'Reilly's MySQL [URL="http://en.oreilly.com/mysql2010"]Conference[/URL] to Edward Screven, [URL="http://www.oracle.com"]Oracle[/URL]'s chief corporate architect, while he announced Oracle's grand plan for MySQL. What they heard was that Oracle is interested in MySQL, will invest in it and nothing should change for the community version of MySQL. … |
| | [URL="http://blogs.zdnet.com/perlow"]Jason Perlow[/URL] and I had the pleasure of interviewing [URL="http://www.kickfire.com"]Kickfire[/URL] CEO Bruce Armstrong for the May 22nd episode of [URL="http://www.blogtalkradio.com/frugalfriday"]Frugal Friday[/URL] to discuss the Kickfire appliance. The Kickfire appliance is a Linux-based, rack-mountable, database appliance tuned for Data Warehousing. Here's the real scoop: Starting at a mere $32,000 US, you … |
The End.