Xampp 1.8.3 with phpmyadmin 4.1.12 Storage Configuration NOT Complete

I recently installed the latest Xampp with phpMyAdmin version 4.1.12 and noticed the following error messages after the installation process:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click [here].

… and clicking the link showed the following errors:

$cfg[‘Servers’][$i][‘users’] … not OK [ Documentation ]

$cfg[‘Servers’][$i][‘usergroups’] … not OK [ Documentation ] Configurable menus: Disabled

$cfg[‘Servers’][$i][‘navigationhiding’] … not OK [ Documentation ] Hide/show navigation items: Disabled

The fix is simple:

STEP1:

Run the following query on the phpmyadmin database:

==================== START ===================

CREATE TABLE IF NOT EXISTS `pma_users` (

  `username` varchar(64) NOT NULL,

  `usergroup` varchar(64) NOT NULL,

  PRIMARY KEY (`username`,`usergroup`)

  COMMENT=’Users and their assignments to user groups’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

 

CREATE TABLE IF NOT EXISTS `pma_usergroups` (

  `usergroup` varchar(64) NOT NULL,

  `tab` varchar(64) NOT NULL,

  `allowed` enum(‘Y’,’N’) NOT NULL DEFAULT ‘N’,

  PRIMARY KEY (`usergroup`,`tab`,`allowed`)

  COMMENT=’User groups with configured menu items’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

 

CREATE TABLE IF NOT EXISTS `pma_navigationhiding` (

  `username` varchar(64) NOT NULL,

  `item_name` varchar(64) NOT NULL,

  `item_type` varchar(64) NOT NULL,

  `db_name` varchar(64) NOT NULL,

  `table_name` varchar(64) NOT NULL,

  PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)

  COMMENT=’Hidden items of navigation tree’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

==================== STOP ===================

STEP2:

Add the following lines to your phpMyAdmin config.inc.php file:

$cfg[‘Servers’][$i][‘users’] = ‘pma_users’;

$cfg[‘Servers’][$i][‘usergroups’] = ‘pma_usergroups’;

$cfg[‘Servers’][$i][‘navigationhiding’] = ‘pma_navigationhiding’;

STEP3:

Logout and log back into phpMyAdmin

That’s it!

Enjoy 😉

 

Update:

Upgrading to phpMyAdmin 4.2.5 caused a similar problem but with ONLY one error.

$cfg[‘Servers’][$i][‘savedsearches’] … not OK [ Documentation ] Saved searches: Disabled

The solution is simply the same as above…

Execute the following query:

==================== START ===================

CREATE TABLE IF NOT EXISTS `pma_savedsearches` (

  `id` int(5) unsigned NOT NULL auto_increment,

  `username` varchar(64) NOT NULL default ”,

  `db_name` varchar(64) NOT NULL default ”,

  `search_name` varchar(64) NOT NULL default ”,

  `search_data` text NOT NULL,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)

)

  COMMENT=’Saved searches’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

==================== STOP ===================

STEP2:

Add the following lines to your phpMyAdmin config.inc.php file:

$cfg[‘Servers’][$i][‘savedsearches’] = ‘pma_savedsearches’;

STEP3:

Logout and log back into phpMyAdmin


Posted in Vista, Web Design, Windows, Windows 7, Windows Vista, Windows XP and tagged , , , , , by with comments disabled.

VirtueMart – Terms Of Service on Joomla 2.5.9 Doesn’t Work

Just as indicated in my earlier post, I’m having troubles making the ToS on my customer’s site work. I later got an idea from VirtueMart forum. Actually, my problem was not having a link to the ToS and got this fixed by editing the laguage file for virtuemart component. If you have similar problems just follow these steps:

1.) Use your favourite editor to open language/en-GB/en-GB.com_virtuemart.ini

2.) Search for “COM_VIRTUEMART_CART_TOS_READ_AND_ACCEPTED” (line 99 on Joomla 2.5.9/VirtueMart 2.0.18a)

3.) Edit and change to:

     <a href=http://www.mydomain.com/index.php/path-to-ToS target=”_new”>Click here to read terms of service and check the box to accept them.</a>

Your ToS should now be linked properly.

 

*) If you use a different language outher than english, you need to change the settings also in that language file same like above but translated as wished. My customer’s web site uses german as the default language for example and the settings is as follows:

1.) Use your favourite editor to open language/de-DE/de-DE.com_virtuemart.ini

2.) Search for “COM_VIRTUEMART_CART_TOS_READ_AND_ACCEPTED” (line 99 on Joomla 2.5.9/VirtueMart 2.0.18a)

3.) Edit and change to:

     <a href=http://www.mydomain.com/index.php/path-to-ToS target=”_new”>Bitte lesen und bestätigen Sie Ihr Einverständnis mit den <em>Allgemeinen Geschäftsbedingungen</em>.</a>


Posted in VirtueMart, Web Design and tagged , , by with 1 comment.

VirtueMart – Terms-of-Service Checkbox Field Shows Up With ToS Disabled

I’m having troubles making the TOS (Terms Of Service) on my cutomers web site work. After much troubleshooting and research on Google, I discovered that the issue has already been reported  on this forum https://forum.virtuemart.net/. There I found the solution and decided to post it here for future reference. Maybe this might help someone else.

This web site in question is using VirtueMart 2.0.18/Joomla 2.5.9

Problem:

After configuring the “Terms Of Service” (shop –> vendor) and making sure the following are activated, the TOS simply cannot be viewed. On the checkout page, the link to the TOS is same as the main index page. (example: http://www.mysite.com/)

a) Must agree to Terms of Service on EVERY ORDER? [checked] (Configuration –> Checkout)

c) agreed (Configuration –> Shopper Fields –> agreed – checked and click required)

Solution:

As there is not fix at the moment, I decided to disable this feature for now by unchecking option “a and b” above. While the TOS link is removed from the checkout page, the checkbox will remain untill you perform the option “c” make sure “Not Required” ist clicked this time.

 

Summary:

VirtueMart v2.0.18 / Joomla 2.5.9

To disable the “Terms Of Service”, do the following:

a) Must agree to Terms of Service on EVERY ORDER? [unchecked] (Configuration –> Checkout)

b)Show Terms of Service on the cart/checkout? [unchecked]

c) agreed (Configuration –> Shopper Fields –> agreed – checked and click Not Required)

I hope this will help someone in search for solutions to these problems.


Posted in VirtueMart, Web Design and tagged , , by with 2 comments.

Knowledgebase – Useful Links

Linux

1.) Linux Servers: http://www.brennan.id.au/index.html

2.) Fix FTP Passive mode Problems: https://www.gosquared.com/blog/archives/936

3.) Ways to add swap space using ‘dd’: http://www.thegeekstuff.com/2010/08/how-to-add-swap-space/

4.) CentOS 6.3 Netinstall Guide: http://www.if-not-true-then-false.com/2011/centos-6-netinstall-network-installation/

5.) Linux User Guide: http://www.comptechdoc.org/os/linux/usersguide/index.html

 

Windows


Posted in Linux, Networking, Web Design, Windows and tagged , by with comments disabled.

Web sites can’t be loaded.

This Tip comes from gulli

Why searching for solutions to other problems, I just came across this and wanted to put it here for other people visiting.

The are some situations when connecting through DSL, Router etc. and some web sites can’t just be loaded. You can try the following below.

  1. Start> Run> and enter ping -f -l 1492 www.omotech.com
    (or any other web address instead of www.omotech.com).
  2. You’ll see responses like “Packet needs to be fragmented but DF set”. Gradually reduce the number little by little (let’s say by 10), until the server responds with connection time (in my case 1472).
  3. Start> Run> Regedit>HKEY_LOCAL_MACHINE>system> CurrentControlSet> Services>Tcpip> Parameters>Interfaces: you’ll find many folders with all kinds of numbers and letters. Search in these folders for the one that has your IP numbers.
  4. Create in this folder a new key (Right Click> New> DWORD (32-bit) Value) with the name “MTU”.
  5. Assign a new value to the Key. (Double click MTU)> enter the value you just emitted from the ping responses above (e.g 1472).
  6. With a bit of luck, you should be able to get those web sites loaded


Posted in Networking, Web Design and tagged , by with comments disabled.

How To Create And Install A favicon.ico

What is a Favicon

Favicon is short for “Favourites Icon” (“Favorites Icon” for you
Americans ;). The name is derived from the bookmark list for Microsoft
Internet Explorer which is called Favorites/Favourites list.
When you add a site to your Favourites/Favorites list,
Internet Explorer (version 5 and above) asks the server if it has a file
called favicon.ico.
If present, this file will be used to provide an icon that is displayed
next to the bookmark text.

Other browsers such as Mozilla have also added support for favicons. Depending
on the browser, the favicon can appear in a variety of places, not just in the
bookmarks list (in fact, it may not even appear in the bookmark list at all).
It may be shown in the address bar or the title of a browser
tab, for instance.


How to create a Favicon

To create a favicon.ico simply create a 16×16 .PNG file and convert it
to an icon resource with png2ico. If you want, you can add more images to
the same icon resource to provide alternative resolutions. Most
browsers only use a 16×16 image but in a different context (e.g. when you drag
a URL from the address bar onto your desktop) a larger icon may be shown.
If the icon resource only contains a 16×16 image, this will be scaled to the
appropriate size, so technically there is never a need to add alternative
resolutions. However, doing so can increase the quality of the displayed icon.

Keep in mind that for a user with a slow modem a favicon.ico may increase
the page loading time by a few seconds if it is too large, so don’t
overdo it. Adding a 32×32 alternative should be enough to make sure the image
will look good even in contexts with larger icons.
Adding even more and larger alternatives is unnecessary bloat.
Try to keep the number of colors below 16 and create a 16-color icon using
the --colors 16 switch of png2ico (or even create a b/w icon
with the --colors 2 switch). This will result in a smaller
file that loads faster.

When you create the images to include in your favicon.ico, don’t forget
that the icon may be composed against various background colors so
you should use transparency rather than a solid background if you want
to avoid that your icon appears inside a box. Note, that icon resources
only support binary transparency, i.e. a pixel may be visible or invisible
but not something like 30% translucent.


Installing your Favicon

To add your new favicon.ico to a web page put it on the server into
the same directory as the web page it is for
(e.g. www.example.com/foo/favicon.ico for
www.example.com/foo/index.html). That is the first place a
browser will search. If it doesn’t find an icon there, it checks the
top-level directory of the server (www.example.com/favicon.ico
for the www.example.com server), so by putting it there you can have
a default favicon for all the pages in your domain. Depending on
browser and configuration, the favicon.ico is not always
rendered, even if it is in one of the above locations,
unless the web page explicitly declares its presence. To declare that
your web page has an icon, you add the following 2 lines into the
section of your page:



You can also create or convert images (jpg. gif, png etc) into favicon.ico online


Posted in Web Design and tagged , , , by with comments disabled.

Interactive Color Picker

 

 


Hex:
Red:
Green:
Blue:
Hue:
Saturation:
Value:

Open in a new window

 

 


Posted in Web Design and tagged , , , by with comments disabled.

How Can I Make A:Hover (In CSS) Work With Visited Links?

a:hover tag applies to the links
only when they have not been clicked before.

(when a user clicks on the link, goes to the next page and then comes back to
the same page, the link will not look as it was originally)

i tried disabling this by using the same prameters in a:link but the a:hover
stopped working. is there any way to make it work with visited links? or is
there any other tag that has the same effect as a:hover?

Here are the CSS a: classes.

a:link {color: #FF0000} /* unvisited link */
a:visited {color: #00FF00} /* visited link */
a:hover {color: #FF00FF} /* mouse over link */
a:active {color: #0000FF} /* selected link */

These need to be defined in this order or it won’t work (according to the
w3schools).

A:Visited {
font-family:verdana;
font-weight:bold;
color:black;
text-decoration:none;
}

Here are the CSS a: classes.

a:link {color: #FF0000} /* unvisited link */
a:visited {color: #00FF00} /* visited link */
a:hover {color: #FF00FF} /* mouse over link */
a:active {color: #0000FF} /* selected link */

These need to be defined in this order or it won’t work (according to the
w3schools).

just an added tip

your link psuedo classes must be in the following order or they will cause
trouble in some browsers

:link
:visited
:hover
:active

I’ve recently been playing w/
this same scenerio as I build the new site for OU Sooners e-comm site and one
trick is to make sure you have link elements listed in this order because after
all you’re working w/ “Cascading” SS ( in short make sure a:hover is
listed after a:visited)

a link
a visted
a hover

Dont forget you can always set a .class style you like for your text links
before hand (i.e enclosed in a div tag) then after your links take on thier
style you can apply an inline style to your links. ( if that makes anysense at
all)

What browser are you using?
a:hover works the same on visited and unvisited links in IE6 and Firefox 1.5.
Obviously the hover style has to be different from the link or visited style to
be visible.

If you define a:visited {} with
the same styles as the as a {} then your links should always look the same and
a:hover {} should work just fine.

you have to make sure there is no
a:visited set in your style sheets anywhere.

If that doesn’t work you will have to use JavaScript, which can get
complicated.


Posted in CSS, Web Design and tagged , , by with 2 comments.

HowTo make a background image clickable (link) using CSS

Everyone is telling you this isn’t possible, perhaps because of their attention to precise semantics. No, you can’t literally make a background image clickable, since a background image isn’t an entity that can possess a behavioral property the way CSS is organized. But you can certainly apply a background image to a link, and without needing any transparent image overlays:
#backgroundlink
{
display: block;
height: 100px; (height of the background image)
width: 200px; (width of the background image)
background-image: url(logo.jpg);
}


The anchor tag is naturally inline so you need to make it a block in order to hold a shape without inner content. The height & width are those of the image.
To make this work in a non-CSS user agent as well, you might want to add something like this:
#bglink span
{
display: none;
}


Click my logo

If CSS isn’t enabled, the text link replace the image link.
Click here to see a good explanation of similar technics

Interactive Color Picker

If you need an interactive color picker, just check here


Posted in CSS, Web Design and tagged , , by with comments disabled.