What does this mean?

[Shadeyman]

What does this mean?

I'm hoping its linked to the hangs I get when accessing the FF.

 

[scoop987]

Your SQL query cant be right mate.

I think it should read:

SELECT categories_discount_type FROM cnbargains_shop2.categories WHERE categories_id = '#'

If you use "WHERE" syntax in an SQL query, you will always need to fill out what the data you require is equal to, in the above example, it equals to "#".

Again, you probably already know this, but if you are using variables in the query, make sure they are secured.

 

[Shadeyman]

I don't have a clue what your on about, sorry.

While using my laptop to access my shopping basket on a site this error popped up so I took a screen shot of it. Thought the hangs I sometimes get here on the FF might have something to do with my laptop as both errors had MySQL in them. :shrug:

Is this error related to my laptop or something to do with the site I was shopping on?

 

[scoop987]

Its server side mate, dont worry about it, its the websites fault

 

[fingers99]

MySQL is a database used to run a lot of websites. Someone (or, rather, two people) simply made a coding error. It'll have no effect on your computer.

 

[Magic Johnson]

It's actually a DBMS.

 

[ChrisUK]

It's actually a DBMS.

:shakehead:

 

[fingers99]

MySQL is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MySQL are speed, robustness and
ease of use.

From the Debian package manager's description. I've no idea what a DBMS is

Damn Bugger Micro Soft?
Data Base Module Server?
Dull Boring Message Supplier?

It's still a fooking database, much as it was when I last used it ten or twelve years ago...........

 

[Magic Johnson]

you never truly access a database, the management system does it all for you.

 

[ChrisUK]

From the Debian package manager's description. I've no idea what a DBMS is

Damn Bugger Micro Soft?
Data Base Module Server?
Dull Boring Message Supplier?

It's still a fooking database, much as it was when I last used it ten or twelve years ago...........

It means Database Management System - this is one of the many reasons the IT industry is f***ed.

It's still a f***ing database. Running SQL quieries directly on a linux shell is DIRECTLY accessing / updating the database using the commandline SQL client.

The management system element comes into play when you start using noddy GUI management tools to run clean-up operations etc a lot of which are done automatically nowadays .

 

[Magic Johnson]

Lol did I strike a nerve there Chris?

 

[ChrisUK]

Nah not really - don't touch databases anymore, And boy am I happier for it .

 

[Magic Johnson]

I can understand where you're coming from DBAdmin wise, but the MS is a very useful tool, in my opinion. I leave the administrating to my boss.

 

[jenks69]

Nah not really - don't touch databases anymore, And boy am I happier for it .

Snap! i used to be responsible for a large MS SQL database, and another that was not so large but needed 24/7 availability. I reckon 60% of my thinning hair can be attributed to those two DB's

 

[fingers99]

So, if I "access" MySQL through bash (command line), I'm not using a DBMS? That makes ense to me. After all, otherwise when I do command line ftp (God help us), I'm using a FTPMS? (File Transfer Protocol Management System)

My guess (and I'm not going to enter the dark side to find out) is that the version of MySQL for Windows actually comes bundled with a GUI. In *nixen, you can choose the GUI/Management System, and choose whether to use one or not.