I have the following query....
UPDATE vehicle_catalog SET parent_id = 0 WHERE parent_id = SUBSTR(id, 0, 5)
I need to set all parent_ids to 0 where the first 5 characters of id is the same as the parent_id. This is effecting 0 rows when I'm looking at the data and it should be effecting over 10,000.
Any ideas on why this wouldn't be effecting…
I tried to install the openoffice.org package but it gave an error. Now i cannot repair, remove or install nothing. The Software center of xubuntu gives this error log. Nothing seems to solve this. I tried apt-get install -f but it does not solve the problem either. Any suggestions?
installArchives() failed: (Reading database ...
(Reading…
Loading of revision3.com in Chrome stops and status saying "waiting for static.inplay.tubemogul.com"
grooveshark.com in Chrome never loads
But wikipedia.org, google.com works just normal
same behavior in Firefox too.
I use wired DSL connection in Ubuntu 12.04. I guess this started happening after I upgraded the Chrome browser or Flash…
I have recently migrated from Windows to Ubuntu.
My current locale shows below output :-
cha@COMPUTER:~$ locale
LANG=en_IN
LANGUAGE=en_IN:en
LC_CTYPE="en_IN"
LC_NUMERIC="en_IN"
LC_TIME="en_IN"
LC_COLLATE="en_IN"
LC_MONETARY="en_IN"
LC_MESSAGES="en_IN"
LC_PAPER="en_IN"
LC_NAME="en_IN"
…
I received the following email from one of my readers.
Dear Pinal,
I am new to SQL Server and our regular DBA is on vacation. Our production database had some problem and I have just restored full database backup to production server. When I try to apply log back I am getting following error. I am sure, this is valid log backup…
In yesterday’s blog post we learned the importance of the Relational Database and NoSQL database in the Big Data Story. In this article we will understand the role of Key-Value Pair Databases and Document Databases Supporting Big Data Story.
Now we will see a few of the examples of the operational databases.
…
Static Site B has two separate contact form scripts. One script processes leads via a script developed using Cold Fusion. Another script processes leads via a script using MySql Database. New Site A is being developed using WordPress.
How do I use a WordPress Contact Form plug-in to integrate these two scripts (built on…
DB 11.2.0.4 patchset (Patch 13390677) has been released on
Linux x86-64
Linux x86
Solaris on SPARC (64-bit)
Solaris x86-64
HP-UX Itanium
IBM AIX on Power Systems
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Additional details about list of bug fixes and known…
I recently got following email from one of the reader.Hi Pinal,Even thought my database is in full recovery mode when I try to take log backup I am getting following error.BACKUP LOG cannot be performed because there is no current database backup. (Microsoft.SqlServer.Smo)How to fix it?Thanks,[name and email removed as…
During the life of any database there will be times when the development makes a change that breaks functionality of an object somewhere else in the database. SQL Server does a good job in some places of making this impossible, or at least really difficult, but in other places there isn't even a murmur as you execute a…
This is the first in a series of articles that will develop an ASP.NET application that uses the Entity Framework 4. This article will demonstrate how to use Visual Studio 2010 and the Entity Framework 4 to create a database in a step-by-step approach. The database created in this article will then be used in future…
Are you receiving an error message while taking a DB2 database backup? Or an error message pops up while restoring the database backup? If the answer for any of the above questions is ';yes';, then the... [Author: Mark Willium - Computers and Internet - May 13, 2010]
Hi,
I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary of shared hosting since the one I have tried so far did not seem to have very consistent performance.
One…
Hi there I'm a developer looking at introducing ClickOnce deployment for an internal .NET Winforms application that will be distributed via the corporate network.
Currently the product roll out and updates are handled by Group Policy however I would like to control the updates via ClickOnce deployment now.
…
I recently had an incident in which several MySQL files were wiped out (mostly from WordPress, but also a few of MySQL’s own files). The IBDATA1 file is unaffected, but several .frm are gone as are a few .myi and .myd files.
So now I need to find out if there is a way to rebuild the missing files from…
This is on VPS\Centos server. The MySQL server is pre configured.
I am running the Java application on Tomcat
My Java web application is not able to connect to the MySQL server.
I get an error -
"Caused by: java.net.ConnectException: Connection refused"
I suspect this to be a configuration problem…
I just got a nasty surprise when I installed a website in Unicode Hindi (Indian language) on a server, all freshly entered unicode data is turning into question marks on the server. On my dev machine it works perfectly.
I found that I have MySQL version 5.0.45 (installed in default by Plesk I guess).…
Hi,
My server details:
OS: Windows Server 2003
IIS6
Plesk 8.xx installed (currently using Plesk to set the cronjob)
I need your advice. I have 2 methods:
Method 1:
Using php + mysqldump, create databases backup files into gzip, and then send email with attachment (each databases has around about…
I have been trying to set up a backup script on a windows server. I have used pgAgent (scheduling for pgAdmin), to run the backup script. No problems with the backup script.
However, my jobs are not running like they should. I have set both the schedule, and the steps.
I am fairly certain, that I am…
I'm trying to set up phpPgAdmin on my test machine so that I can interface with PostgreSQL without always having to use the psql CLI. I have PostgreSQL 9.1 installed via the RPM repository, while I installed phpPgAdmin 5.0.4 "manually" (by extracting the archive from the phpPgAdmin website). For the…
I've applied for an internship at a startup company that expects its user base to grow by a large factor in a small amount of time, and so part of their project is to scale everything up so that they're ready: handling more/larger requests efficiently, handling server failures, load balancing,…
I have been looking at logging only certain users activity in MySQL. I found that the logging could be enabled or disabled for all users but one of the service using the db does a lot of queries and therefore I would like to only log specific users.
Google told me that a flag can be SET to…
I just got a nasty surprise when I installed a website in Unicode Hindi (Indian language) on a server, all freshly entered unicode data is turning into question marks on the server. On my dev machine it works perfectly.
I found that I have MySQL version 5.0.45 (installed in default by…
I am reviewing quote for a server upgrade. (RHEL).
The server will have both Apache and MySQL on it, but the reason for upgrade is to increase DB performance. CPU has been upgraded massively, but I know that disk speed is also a factor.
So RAID 10 is faster performance than RAID 5,…