I have an article that I want to publish on my Joomla! site. Every time I click apply or save. I get error 500 - An error has occurred! DB function reports no errors. I have no idea why this error comes up, al I can think is that it's a server error. I'm using TinyMCE to type articles together with Joomla! 1.5.11. Updated: I turned o...
Alright... this seems complicated for me.. I don't know if it is. filename: add_types.js I have some data, which i create into mysql db (is for a back-end system). through jquery/ json. It work fine. var last_id = data.last_id; var fck_editor = data.fck_editor; var new_data = '<div id="input_highlight'+last_id+'"><strong...
I have this table : And I would like to make a request that would return for each deal_id the row with the highest timestamp, and the corresponding status_id. So for this example, I would have returned 2 rows : 1226, 3, 2009-08-18 12:10:25 1227, 2, 2009-08-17 14:31:25 I tried to do it with this query SELECT deal_id, status_id, ma...
Hello, I have a simple question but I don't know which term I should use to find the answer (english is not my first language). I have a classical database design of products like and categories. CREATE TABLE IF NOT EXISTS `a` ( `id_a` int(11) NOT NULL auto_increment, `type` varchar(255) NOT NULL, PRIMARY KEY (`id_a`) ) ENGINE=M...
Hi all, While i am browsing my online app in the server i got an error like Database Connection Failed User coule_com@c17564 already has more than 'max_user_connections' active connections. But this is working well in my local system. And this error occurs ANY TIME when i navigate in the server. If i refresh the browser i can able t...
How to connect with MySQL from Visual C++ Microsoft Visual Studio 2008 ? I tried googling and found solutions all of which ended with fatal errors like linker errors,... etc. Please explain (or provide a link) step by step, including prerequisites (with links) and all details. I don't need any query examples.. just connecting to MySQL. T...
Take a look at the MySQL table below called "Articles": +----+-----------+---------+------------------------+--------------------------+ | id | articleId | version | title | content | +----+-----------+---------+------------------------+--------------------------+ | 1 | 1 | 0.0 | ArticleNo....
Hi All, I want to know if mysql TEXT data type reserves any space even if there is no data in that row? I am little confuse. Can anyone provide me any input on this. Thanks in advance. ...
I'm developing a web app that will access and work with large amounts of data in a MySQL database, something like a dictionary/thesaurus. I need to test the performance of the DB as its size increases, so I know how slow each request will be in the future. Any ideas? Like are there specific tools to check DB performance for a particular...
Thank you one and all for you're answers. I'm learning as I'm going - so I'm learning but still got a long ways to go. For work, we primarily use MySQL for our databases - web development. I have a question concerning unique indexes - when to use them properly and how. I'm sure pretty I understand their purpose - declare a column as a ...
I already set up MySQL connection pool in Glassfish using JNDI. I only execute one query at a time but use the same sql instance. Everything seems to work fine except creating temporary tables and use them. In short, even though after I create a temporary table, insert query does not work since the table does not exist. Are there any con...
How do I change the following dependent subquery to self join? SELECT d.name, d.created, (SELECT SUM( q1.payout ) FROM client AS q1 WHERE q1.uid = d.uid) AS payout, (SELECT COUNT( q2.uid ) FROM client AS q2 WHERE q2.uid = d.uid AND q2.winning =1) AS cnt FROM client AS d group by d.name, d.created ORDER BY cnt DESC LIMIT 0 , ...
MySQL server version 5.0.45. Consider the following: ( SELECT CASE WHEN t.group_id = 12 THEN 'yes' ELSE 'no' END FROM sample_table t WHERE t.user_id = 2 AND t.group_id = 12 ) as foo This subquery of a larger statement works as I'd expect, yielding a 'yes' or 'no' string value most of the time. It's not ideal...
Hi, We use a monitoring solution (zabbix). It stores trends data (MySQL 5.X) using a table called trends_uint with the following structure (simplified): itemid clock value_avg 1 1238774400 100 1 1250773900 70 1 1250773200 50 The clock field stores datetime values using Unix time. I'm trying to...
What are the adventages and disadventages of storing JSON data in MySQL database vs. serialized array? ...
Can anyone see what I am missing? the section of my script below fails with the following message: ERROR 1064 (42000) at line 26: 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 ') , PRIMARY KEY (id), INDEX fk_gaprodsku_gatransid (transactionid...
Simple doubt, the title says it all. =) ...
We have a (currently InnoDB) table which contains roughly 500,000 rows. This represents a queue of tasks to run. It is stored in a MySQL database. An a continual basis, at least once per second but sometimes more frequently, we select data from it and subsequently update some rows. Once per day, we prune old rows from the table. We ...
Hi, I'm making one MySql script that break one string field in multiple words. I need something like the explode function in PHP! I try the mysql substring_index function but I have to expecify the number of occurences of the one substring. And that is not predictable in one 10.000 row table. Any sugestion? this is my actual Stored ...
I use EntityFramework in a project to connect to a Mysql database. The provider is Devart Dot.connect. This application needs to connect to a database using connexion parameters given by the user at runtime. This includes of course the Mysql Database name. I used the EntityConnectionStringBuiler and EntityConnection classes to build-up...