256 Kilobytes

Databases > Errors

Type All Category DatabasesDiscuss database design and development, such as relational and NoSQL technologies like MySQL, MariaDB, and MongoDB. Tag Errors

Profile Photo - Some Guy

How to fix "Every derived table must have its own alias"?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

Last ReplyImagine a table called purchases that records purchases made by customers at stores, i.e., it's a many to many, and the software needs to know which c... Univa,

Imagine a table called pu...

Sun, 05 May 2019 03:27:34 -07002 years ago1
🗨 1
🐏 0
👁 510
Profile Photo - Some Guy

How to fix "Operand should contain 1 column(s)"?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

Last ReplyThis error can occur if you accidentally use commas instead of AND in the ON clause of a JOIN. FOR EXAMPLE: JOIN joined_table ON (joined_table.c... Univa,

This error can occur if y...

Thu, 18 Apr 2019 07:57:10 -07002 years ago1
🗨 1
🐏 0
👁 526
Profile Photo - Some Guy

Solve "trying to get property of non-object"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyYou're probably trying to get the value from an array with object syntax. Most database data is handled in arrays, not objects. If you are d... Hash Brown,

You're probably tryin...

Sun, 20 Jan 2019 18:29:51 -08002 years ago1
🗨 1
🐏 0
👁 480
Profile Photo - Some Guy

Solve "sqlstate[hy000] [2002] connection refused"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyThese errors are kind of generic and don't point to anything specific. In general you want to start off: Make sure you're using the c... Hash Brown,

These errors are kind of...

Sun, 20 Jan 2019 18:05:00 -08002 years ago1
🗨 1
🐏 0
👁 532
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyIf you are getting this error while connected to a remote terminal via SSH (such as to a web host), there may be a non-root account that you are meant... August R. Garcia,

If you are getting this e...

Sat, 22 Dec 2018 08:22:52 -08002 years ago1
🗨 1
🐏 0
👁 342
Profile Photo - Some Guy

Solve "Column count doesn't match value count at row 1"?

Answers in Databases | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyThis error can occur if you are missing If your insert statement does not specify the number of columns correct. Example of incorrect statement:... August R. Garcia,

This error can occur if y...

Thu, 20 Dec 2018 01:18:24 -08002 years ago1
🗨 1
🐏 0
👁 355
Profile Photo - Some Guy

Solution to "string or binary data would be truncated"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyHello, Trunication is basically where you're going to lose some of your data by inserting it. This is cause by trying to pass in data which is... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:40:51 -08002 years ago1
🗨 1
🐏 0
👁 358
Profile Photo - Some Guy

ORA-00979: not a group by expression - solutions?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyHello, ORA-009779 is a fairly straight forward error. You have not included any code so I'll have to explain what it's likely to be... I... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:36:33 -08002 years ago1
🗨 1
🐏 0
👁 390
Profile Photo - Some Guy

How to fix "unknown 'column name' in 'field list'"?

Answers in Databases | By Some Guy

Published | Last Update

Profile Photo - Hash Brown

Last ReplyHello, This is really easy, the column name you have refferenced (rabbit_name) does not exist. Check the spelling, or add the column to the tabl... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:22:55 -08002 years ago1
🗨 1
🐏 0
👁 342
Profile Photo - Some Guy
Profile Photo - Some Guy

I'm getting tossed an error that sa...

MoreI'm getting tossed an error that says "Fatal Error: call to undefined function mysql_connect()". Can somebody tell me how to solve this...
🗨 0
🐏 0
👁 349
Profile Photo - Some Guy
Profile Photo - Some Guy

How do I fix the error "a foreign k...

MoreHow do I fix the error "a foreign key constraint fails" when adding or updating a child row?
🗨 0
🐏 0
👁 328
Profile Photo - Some Guy

How to fix "#1273 - unknown collation: 'utf8mb4_unicode_520_ci'"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I am doing some web development in Wordp...

MoreI am doing some web development in Wordpress but I'm coming across what I believe is a server error. How do I deal with this error: #1273 - unkno...
🗨 0
🐏 0
👁 395
Profile Photo - Some Guy

Why can't I add foreign key constraint?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I need to add foreign key constraint but...

MoreI need to add foreign key constraint but I cant. why can't i and how can i do this?
🗨 0
🐏 0
👁 297
Profile Photo - Some Guy

Fix "Insert statement conflicted with foreign key constraint"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I'm using MySQL to manage data on a...

MoreI'm using MySQL to manage data on an SQL server I have, and it's been giving me this error that says the insert statement conflicted with th...
🗨 0
🐏 0
👁 333
Profile Photo - Some Guy

Fix "access denied for user 'root'@'localhost' (using password: no)"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I keep getting the following error messa...

MoreI keep getting the following error message : "access denied for user 'root'@'localhost' (using password: no)". So far I...
🗨 0
🐏 0
👁 281
Profile Photo - Some Guy

How to fix "Can't connect to local mysql server through socket"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

In my connection server, there is a erro...

MoreIn my connection server, there is a error which shows up saying "Can't connect to local mysql server through socket". Why am I getting...
🗨 0
🐏 0
👁 277
Profile Photo - Some Guy

Getting error "Mysql server has gone away"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I am setting up a new server for my busi...

MoreI am setting up a new server for my business and have been doing the SQL configuration to manage the data that our web app uses. Last time I started...
🗨 0
🐏 0
👁 296
Profile Photo - Some Guy

Fix "Tuple index out of range"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I'm running a simple python program...

MoreI'm running a simple python program that will display the data from my SQL database in a tinter form and its stating the tuple index is out of ra...
🗨 0
🐏 0
👁 303