Items filtered by date: December 2015

ckeditor straight from the original designers, which now have done this joomla plugin still messes with your html and code preventing geshi.

There is an easy solution to protect any code within specified tags.

• In the components menu
• goto the advanced tab
• paste the following code in to the Custom Javascript configuration
  

  CKEDITOR.config.protectedSource.push( /{code[\s\S]*?}[\s\S]*?{\/code}/g );
  CKEDITOR.config.protectedSource.push( /{geshibot[\s\S]*?}[\s\S]*?{\/geshibot}/g );

• As you can see there is 2 lines, one is to protect everything within {co de}{/co de}and {geshi bot}{/geshi bot} tags (without the spaces). you can also make you own.
• I have left Html entities enabled as they do not affect code inside protected storage

when you go to login to the joomla admin section you only get a blank or white screen

• try internet explorer
• enable javascript in firefox (this is usual culprit)
   

• interleaving = packet manipulation
• quite line test = 17070
• 'Copperline Test' can only be done form the line rental supplier and can provide a more extensive line test
• BT can guess if router/filter straight into master socket by checking impedance of the line. not 100% reliable
• when you are plugged in to the master socket and you ring BT they will do an automatic profile reset.
• according to the BT woman, BT can detect wheather you are plugged in to the test socket

** this csv export procedure might not maintain cariage returns and will need adjustment if so. CKeditor QuickFaq article is a good example **

This is a worked example of exporting data from a QuickFaq via csv, data manipulation in libre office and then importing the articles into K2. The articles contain full html and must not be modified or escaped. This custom routine will work for migrating all sorts of data to and from a MySQL database with html, or not, without loosing any data

Exporting Data out of QuickFaq

• export with phpmyadmin with the following settings:

export type CSV
fields terminated by    ,
fileds enclosed by    ¬¬¬replaceme¬¬¬
fields escaped by
lines terminated by
replace NULL by

Remove CRLF characters within fields - not ticked
Put fields names in the first row - ticked

NEW Terms in PHPMyadmin - still checking (29-05-14)

export type CSV
Columns separated with:    ,
Columns enclosed with:    ¬¬¬replaceme¬¬¬
Columns escaped with:
Lines terminated with:
Replace NULL with:

Remove CRLF characters within fields - not ticked
Put fields names in the first row - ticked

• use notepad++ and replace all " with ""
• use notepad++ and replace all ¬¬¬replaceme¬¬¬ with "
• should now be importable as a cvs into libre office

Import CSV in to libre office

The csv export should now be imported into libre office with the following settings. The purpose of this step is so that the exported data can be matched up to the data structure of the K2 articles and categories

• character set    Unicode (UTF-8), this assumes thats what your charater set is using. (the other optin is possibly Western Europe (ISO-8859-15/EURO) if you are using Latin). There should be no Bomb Characters, this shows there is a character that cannot be handled. I think unicode is probably a complete implementation of Unicode.
• Language - Default (UK) - should not make any difference
• from row 1
• separated by    ,  (comma)
• Text delimiter   "
• leave everything else

Notes

• K2 import/export module makes all " go to ""   , this seems to be the key for a successful import.
• when you then import this using open office after doubling up the ", the import process removes a " out of each pair making it the syntax appear correct once the spreadsheet opens.

Importing Data into K2

i used navicat as phpmyadmin had some issues with not setting an escaped character.

• open navicat and then select the K2 items table
• run the import wizard in navicat
• Select the appropriate csv file (ie QuickFaq Data - Ready for import into K2.csv)
• leave encoding as 65001 (UTF-8)
• next
• select comma (,) for the Field delimeter, leave Record separator as CRLF (doesnt seem to make any difference), Text Qualifier as "
• next
• change first data row to 2
• change the date settings (might be different for different csv but we will use QuickFaq to K2)

Date order    YMD
Date delimiter    -
Time delimeter    :
DateTime Order    Date Time (should be unchanged)
Decimal symbol    . (should be unchanged)

• next
• all fields should match up here
• next
• select Copy delete all records in destination, repopulate from the source
• next
• click start
• there should be no errors for a successful import 

Additional notes, these might not be required but when these instructions are used again can be pruned or merged.

on the working csv there only seems to be 1 LF at the end whereas the one that does not work has CRLF

\n = linefeed
\r = carriage return

solution is to use the pipe symbol the vertical line, seperating thing does not like multiple symbols

use CSV for export

Fields terminated by   |
Fields enclosed by     "
Fields escaped by    nothing here
Lines terminated by  nothing here
Replace NULL by NULL (possibly leave this blank)

Remove CRLF characters within fields - unticked
Put fields names in the first row   -   ticked

so unexplained is most likely due to a field seperator present in the html code such as ,";  so use one that is not present and is most likely the pipe symbol. a quick text scan will show it up.

to find the fault, find a break in the file when loaded in office/spreadsheet and then scan for that text in the csv file using notepad++ and this will reveal all.

¦ does not seem to work but give it a go

¬¬¬replaceme¬¬¬

You can test a spam scanner / filter by adding the following code to the body of your email

{code class='brush: text;'}XJS*C4JDBQADN1.NSBN3*2IDNEN*GTUBE-STANDARD-ANTI-UBE-TEST-EMAIL*C.34X{/code}

• If your anti-spam detects it and marks it as spam then it's working.
• This is a generic spam test string.
• If it does not get filtered by your email client, it might be that you email client is ignoring the spam headers in the email or it is not sufficiently high enough.

when you try and install a HP printer which is located on a windows XP PC via network share on a windows vista or windows 7 computer you will run in to configuration issue. Only the following method will allow this configuration to work.

Don't use hp setup utility

• install HP Universal Printer Driver - PCL6 is prefered
• then manually setup printer via port name and select printer appropriate driver
• delete unneeded ports as they can cause errors.

Sometimes whatever you do, windows updates fail.

The solution is to not install all updates at once. It seems if some updates are installed before others it causes a failure which in turn causes windows to revert all changes. The usual culprit is the .NET framework stuff and sometimes drivers

These are issues i have come across when upgrading prestashop either using the autoupgrader or upgrading manually.

upgrade will not work says fopen url is not activated etc...
--
add php.ini with allow_url_fopen = On in the admin/autoupgrade folder

Here is a useful link to some other issues and solutions regarding upgrading.

Upgrading to 1.4.5.1 - Frequently Asked Question

The Simple Management Network Protocol (SNMP) Service on Windows is available for Windows XP/Vista/7/2003/2008 to add monitoring capabilities and expose key information to other computers on your network. Once enabled, software can monitor OID (Object Identifiers) exposed by SNMP. By default, this service is not installed; however, it is easy to install and configure.

The software that i would recommend to use for monitoring SNMP is a complete IT solution for the small business network, Spiceworks.

The following links are to articles on how to setup SNMP.

• Install, Enable and Configure SNMP on Windows
  This covers all versions of windows
• SNMP for Windows 2000/XP
  This gives individual descriptions of the options and makes them clearer
• Configure SNMP Agent in Windows 2000/XP/2003
  This is simple article on the above
• Install and Enable SNMP Service in Windows XP, Vista and 2003
  This is a simple article on the above

When you start a Windows Vista-based computer, you may receive the following Stop error message on a blue screen:

0x0000C1F5

This issue can occur if the system file $TxfLog file has become corrupted. The Common Log File System (Clfs.sys) driver does not fix the $TxfLog file when the file becomes corrupted. In addition to the Stop error message, Windows Vista may not start until the offending disk is removed or repaired.

To resolve this issue the corrupted file needs to be repaired.

Solution 1:

This can be accomplished by booting to an installation disk that has the ability to self heal this type of issue. This can be done with a Windows 7 Beta installation disk. To recover a Windows Vista volume with Stop Error 0x0000C1F5 without data loss, perform the following steps:

1. Obtain a Windows 7 Beta or later Windows 7 installation disk
2. Insert the disk into the disk drive and boot from this Windows 7 Beta installation disk
   
   Note: Once booted, cancel out the Windows7 setup. Do not install Windows 7.
    
3. Once the system has booted successfully, remove the Windows 7 Beta installation disk and reboot the computer from the hard drive.

Note: The Windows 7 Beta installation disk includes self-healing code that resets the corrupted $TxF RM log file, therefore the problematic volume should be recovered by simply booting from the Windows 7 Beta installation disk.

Solution 2:

If solution 1 fails and gives you the same error even when you boot of the OS bootable media your only course of action is the following which will fix the probloem in all cases but has an extra step

1. remove the offending harddrive
2. attach it to a working windows PC, Vista or Windows 7 is prefered via a USB adapter (other mconnection methods might work). Connect it when windows is booted and running
3. you should see that you can see the files on the disk (might not be able to in all cases)
4. chkdsk the faulty partition / harddrive. i would check the whole disk while i was at it but most likely not required
5. chkdsk should find errors and repair them
6. done