Category: Code or Hosting

  • MySQL to MySQL move of data!

    Sometimes you want to move a database between hosts, this is an easy way to cut down on the clutter created in the process, is to output the backup directly to the new host. mysqldump -uExapmleUser -pExapmlePass -hExapmleHostNameOrIp ExapmleDatabaseName | mysql -uExapmleUser -pExapmlePass -hExapmleHostNameOrIp ExapmleDatabaseName

  • SmarterStats error when loading Defaults – Site Defaults Event code: 3005

    An Error Occurred Page: /Admin/Defaults/frmSiteDefaults.aspx Message The page or resource that you are accessing is unavailable or an error has occurred. This error occurred at 11/8/2012 11:00:16 AM and has been logged.   In my Event viewer I saw this error: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 11/8/2012 11:00:16…

  • Slash versus Backslash

    Slash versus Backslash, I saw this image, after googling,

  • Adding a new user to SQL server 2005, 2008, 2010

    Make sure you give the user sufficient permissions to the DB they are being given access to, typically being db_datareader, db_datawriter, db_ddladmin, and public.   There is also a SQL statement you can run: CREATE LOGIN [user] WITH PASSWORD=’password’, DEFAULT_DATABASE=[your_db], CHECK_POLICY=OFF GO CREATE USER [user] FOR LOGIN [user] EXEC sp_addrolemember N’db_datareader’, N’your_db’ EXEC sp_addrolemember N’db_datawriter’, N’your_db’…

  • An inside view as to what apache has going on

    A friend pointed me to this as an option, when trying to find out exactly what is going on with apache, you can run this: ps auxw | egrep “sbin/apache|httpd” | awk ‘{print”-p ” $2}’ | xargs strace “This one-liner will use strace to attach to all of the currently running apache processes output and…

  • Convert a WS_FTP configuration file to a format for FileZilla.

    I originally read about this script here.  Decided to include the script below: #!/usr/bin/php <? /* This script takes a config file from WS_FTP (WS_FTP.ini) and converts it to filezilla format Version 1.0 Author: Andrew Kerr (andrew@arrkerr.com) Credit is given where due in the function headers I make no claims about this program, use it…

  • Unable to Connect to C$ with a UNC connection on Windows Server 2008 (2k8), Windows 7, Windows 8, and Windows Server 2012 (2k12)

    Windows Vista, 7, Server 2008, 2008 R2 and newer Windows operating systems do not allow a user that is NOT the local Administrator access to the UNC location of c$ as it is considered an administrative share. This is a security within UAC (That I recommend leaving intact, I like security). Wiki makes mention of…

  • Generate the code to recreate all non system databases in MSSQL without content.

    The following text will output the SQL statement to recreate all databases: select ‘create database [‘ + name + ‘] go’ from master..sysdatabases Where DBID > 4 You will need to set Results to Text so that the output is correctly formatted. You can then copy users/logins as seen here: http://support.microsoft.com/kb/918992.

  • The file ‘/Skins/B9106EEE-DB03-489D-A19D-8647A55EC15C/control/login_3.ascx’ does not exist.

    When going to http://127.0.0.1:8086/login.aspx?ReturnUrl=%2fInterface%2fDefault.aspx: I would receive the following error: The file ‘/Skins/B9106EEE-DB03-489D-A19D-8647A55EC15C/control/login_3.ascx’ does not exist. Source: WHA.Helm.ControlPanel.dll /login.aspx Page_Load Stack Trace: at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean…

  • Installing Miva Merchant Empresa on Windows 2003 x64

    Install Microsoft Visual C++ 2008 SP1 Redistributable Package (x86) This is a requirement for the next item. The installer can be found here. Initiate the installer, click Nextat the first screen. Click the select box for I have read and accept the license terms. and then click Install >. Click Finish. Install OpenSSL Download the…