and graphic design in Winchester
admin | 9:37 am | April 28, 2008 | Sharepoint 2007
Create a folder: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\BownePortalLayouts
Amend the web.config to point to this folder for the login page…
admin | 4:43 pm | April 21, 2008 | Sharepoint 2007
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033
Copy the attach file in to the above folder
admin | 5:33 pm | March 25, 2008 | Dot net
How to create a strong name for Visual Studio
Go to Start - Program Files - Visual Studio - Visual Studio Tools - Visual Studio 2005 Command Prompt
When the command prompt appears, change directory to your project directory.
Enter the command
sn -k your_strong_key_file_name.snk
A strong key will then be created
Every time you compile an assembly a new GUID is created. A strong key maintains a consistency so that the assembly can be recognised.
admin | 8:54 pm | March 8, 2008 | oscommerce
# $Id$
#
# osCommerce, Open Source E-Commerce Solutions
# http://www.oscommerce.com
#
# Copyright (c) 2002 osCommerce
#
# Released under the GNU General Public License
#
# Empty Data Tables
TRUNCATE `address_book`;
TRUNCATE `categories`;
TRUNCATE `categories_description`;
TRUNCATE `customers`;
TRUNCATE `customers_basket`;
TRUNCATE `customers_basket_attributes`;
TRUNCATE `customers_info`;
TRUNCATE `manufacturers`;
TRUNCATE `manufacturers_info`;
TRUNCATE `orders`;
TRUNCATE `orders_products`;
TRUNCATE `orders_products_attributes`;
TRUNCATE `orders_products_download`;
TRUNCATE `orders_total`;
TRUNCATE `products`;
TRUNCATE `products_attributes`;
TRUNCATE `products_attributes_download`;
TRUNCATE `products_description`;
TRUNCATE `products_notifications`;
TRUNCATE `products_options`;
TRUNCATE `products_options_values`;
TRUNCATE `products_options_values_to_products_options`;
TRUNCATE `products_to_categories`;
TRUNCATE `reviews`;
TRUNCATE `reviews_description`;
TRUNCATE `specials`;
admin | 8:51 pm | | oscommerce
- I used the metatags one cDynamic_Meta_Tags v1.4.zip
- I want to use the Ultimate_SEO_URLS but i have not done that one yet.
- reviews_in_product_info_v1.zip which creates a more Amazon style review system
- The UK Switch and Maestro CC module (I am in the U.K)
- Fixed Width Site With CSS.zip (centres the site)
- No account sign up FEC3.2(means customers get a much quicker checkout process if they want)
- Extra Images (extra_images_with_admin1_3.zip) There are quite a few of those this was just the one i randomly chose and it gives me three images per product.
admin | 4:17 pm | January 25, 2008 | Sharepoint 2007
To update portal workflow ermail:
Quote Request - Customise Quote - Request
Information management policy settings
Select BTS Portal List (Custom Policy)
Ensure that define policy is checked, click ok.
Update email address at the bottom and notification message.
Notification Message can be formatted in HTML
Custom Code for workflow policy:
C:\BTS Portal Development\BTSPortal.Config
Features for custom fields definition
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES
——————————
In order to have different sites (for each client) in different databases, we need to create a seperate site collection for each client.
This is because a site collection can only be linked to one database.
You can have one content database hosting multiple site collections but you cannot divide a site collection into multiple content databases.
1) If you want to backup a site collection you use the command stsadm -o backup.
2) if you want to backup a sub-site in a site collection you use the command stsadm -o export (eg: stsadm -o export -url http://vnbtsweb2/morgan_stanley -filename c:\morgan
)
On Central Administration page:
Go to application management - web application list
test user hruser and password: password
After making a change to the Portal code in C:\BTS Portal Development\BTSPortal.Config you need to rebuild the solution, and unregister the existing entry in the Global Assembly Cache (GAC)
C:\WINDOWS\assembly
Rightclick on BTSPortal.Config and select uninstall
Then drag the new compiled version from
C:\BTS Portal Development\BTSPortal.Config\bin\Debug
to
C:\WINDOWS\assembly
then do an iisreset
Updates to the workflow configuration page need to be copied to:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS
admin | 4:26 pm | December 14, 2007 | oracle
How to troubleshoot connection errors when logging into a supported Oracle database from Toad.
Common Oracle connection errors:
* ORA-12154: TNS: could not resolve service name
* ORA-12505 TNS:listener could not resolve SID given in connect descriptor
* Error: 1.0 [Load Interface dll’s failed]
* Initialization error: Could not find Oracle_Home\bin\oraXYZ.dll
* Initialization error: Could not locate OCI.dll
*OCI.dll, The specified module could not be found
After checking each step in the Connection Worksheet, most connection issues will be resolved. Please note there are extra suggestions for Toad version 7.6 and above.
FOR ALL TOAD VERSIONS:
1. Verify the System path variable contains the desired <Oracle Home>\bin directory and it is listed at the beginning before any other Oracle directories. Toad uses the path to determine the correct directory and will stop at the first one listed in the path. For example, C:\Orawin95\Bin, C:\Orant\Bin or D:\oracle\ora92\ (depending on if you have Win95, NT Win2k, XP, 2003 Operating System).
To verify the value of the PATH variable, from a DOS prompt type: PATH
If the Oracle client path is not at the front of the entire system path statement, select Start | Control Panel | System | Advanced tab | Environment Variables | from the System Variable list, click PATH | click EDIT and move the Oracle path to the front of the entire entry followed by a semi colon.
Below is an example of the PATH:
C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;D:\C:\WINDOWS\system32;C:\WINDOWS;
2. Ensure you can Tnsping (SQL*Net) or Tnsping80 (Net8) your instance. This will validate your connection to the database. From the DOS prompt type: Tnsping <service_name> or Tnsping80 <service_name>
For example:
TNSPING TESTDB
or
TNSPING80 TESTDB
This should return OK in milliseconds.
If you are unable to TNSPING the database, it might indicate that the Database Server is not up and running. Please check with the Database Administrator (DBA) for more information.
3. From the Windows Explorer, search for ORA*.dll in the %Oracle_Home%\bin directory, i.e. C:\Oracle\bin directory. Toad requires an Oracle client to connect to the database, this is a good indication if you have an Oracle client installed. You should find the following dll based on your Oracle client version:
Oracle Version Name of DLL
—————————————-
Oracle 7 Ora7x.dll
Oracle 8 Ora8xx.dll
Oracle 8i Oraclient8.dll
Oracle 9i Oraclient9.dll
Oracle 10G Oraclient10g.dll
If you have multiple dlls in the same folder, rename any that you do not wish to use, as TOAD will use the first one it finds.
For example, if you have ORA806.dll and ORACLIENT8.dll in the same bin directory, it will use ORA806.dll. So you would rename ORA806.dll to ORA806.old to ensure we use the ORACLIENT8.dll.
4. Check the registry via Start | Run | type in Regedit, and look under HKEY_LOCAL_MACHINE | SOFTWARE | ORACLE | ALL_HOMES:
What is the HOME_COUNTER value? If it is more than 1 you will have multiple Oracle homes such as ID0, ID1, ID2, etc up to the HOME_COUNTER value minus one. Simply ensure the LAST_HOME value is the correct ID value which points to the path of the current Oracle_Home. In other words, if ID1 has a path to the C:\Orawin95 on the computer, then the LAST_HOME should have the value 1 since Toad looks to LAST_HOME for the Oracle application extensions.
Example of Registry path where Oracle home resides: (3 Oracle Home install)
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME2
NOTE: For Oracle 10g client, a separate entry is created that does not contain HOME value in the Registry. For example:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1
The computer should recognize the 10g client as the default Oracle client to connect to a particular database. If you would like to use a different Oracle client, refer to Step 1 above to change the PATH, moving the desired Oracle client’s path to the front or refer to the Toad 7.6 or above, Step 1a below to used the Toad Installed Client drop down list.
5. Add the following oci dll command to the Toad Desktop icon Properties by right clicking the icon | select Properties | Shortcut Tab and enter the following after the executable statement in the Target Command line.
For example the Target path will look similar to the following:
“C:\Program Files\Quest Software\Toad\Toad.exe” ocidll=C:\Oracle\Bin\Oraclient9.dll
Refer to the list in point 2 above to determine which client dll to use.
6. Search for the tnsnames.ora file, if tnsnames.ora file is being used as a method of connection. Check that this TNSNAMES.ora file is valid and located in the correct folder. By default (unless specified using the TNS_ADMIN variable), it should be in your %ORACLE_HOME%\Network\Admin folder. Open the tnsnames.ora file via Notepad or a text editor application and verify that all entries are correct such as the HOST, SID/SERVICE_NAME, PORT number information.
If TNS_ADMIN has been set under the registry or as an environment variable, then make sure that the TNSNAMES.ORA file is in the directory specified for TNS_ADMIN.
7. If your Sqlnet.ora file contains NAMES.DEFAULT_DOMAIN entry but the tnsnames.ora aliases does not show proper NAMES.DEFAULT_DOMAIN extension, you may want to try the following:
Add NAMES.DEFAULT_DOMAIN extension for the aliases in the tnsnames.ora file to match your sqlnet.ora.
E.g. If NAMES.DEFAULT_DOMAIN = PROD.QUEST.CORP exists in sqlnet.ora, then make sure “PROD.QUEST.CORP” is add to aliases to get
JLIN10G.PROD.QUEST.CORP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ALV106750)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jlin10g)
)
)
8. If the above suggestions fails to resolve the connection, the Oracle client or SQL*Net components may need to be reinstalled.
Additional troubleshooting suggestions for TOAD FOR ORACLE 7.6 AND ABOVE:
1. From the Toad Server Login window | in the Installed Clients section:
a. Click the drop down list of clients that are installed on the computer | select the desired client to use when connecting to a database.
NOTE: A RED Oracle Client entry means that there is a problem with that particular client and Toad will not be able to connect.
b. Click on the ellipses icon next to Oracle Client drop down list to access the Oracle Home Editor window and check all the HOME paths to make sure they are correct.
c. Click on the SQLNET Editor | verify that the information is correct. Check with the DBA (Database Administrator) for more information.
d. Click on the TNSnames Editor | verify that the tnsnames entries are correct for the desired database.
ADDITIONAL HELP:
Verify hardware and software requirements. Keep in mind that Toad does not support 64bit Oracle Clients.
Refer to the Connection Assistant for assistance on resolving some of the most common errors. This utility contains screenshots to assist with the connection troubleshooting for the following errors:
ORA-12154: TNS: could not resolve service name <ora12154.asp>
ORA-12505: TNS: listener could not resolve SID given in connect descriptor <ora12505.asp>
Error: 1.0 [Load Interface dll’s failed] <error1.asp>
Initialization error: Could not locate OCI dll <OCIdll.asp>
http://support.quest.com/ConnectionAssistant/
admin | 11:03 pm | November 28, 2007 | Sharepoint 2007
To customise a sharepoint masterpage, start with this:
http://www.heathersolomon.com/blog/articles/BaseMasterPages.aspx
The following is a collection of stripped down master pages for your use with SharePoint 2007 sites. The master pages that ship with SharePoint (default.master, blueband.master, etc) are full of formatting code for the respective design for the master page, so to create your own master page you have to copy a master page and strip out all of formatting code (HTML, etc) in the file. With these base master pages, I have done that step for you, plus included comments tagging the Content Placeholders so you quickly identify the Content Placeholders and handle them how you see fit.
For each base master page, there is a link to the code, and a link to a sample screen shot of what your site will look like after applying the master page code.
There is no difference between master pages for a collaboration MOSS site and a WSS site.
While in development, the friendly error page that SharePoint displays when your page has an error can make debugging your master page issues very difficult. You can make an easy change to your Web config file for the site to turn friendly error messages off, therefore providing you with more useful information if your page breaks. Only do the following in a development environment, you would never want to turn off friendly error messages in a production environment. Also be sure to make a back up of the file prior to editing.
Now when your site encounters an error, you will receive a .NET screen outlining the issue instead of the friendly SharePoint error screen. This is particularly useful with dealing with missing Content Placeholders and editing Master Pages. To turn friendly error messages back on, just walk through these steps setting the CallStack to false and CustomErrors mode to On.
To assign the master page to your site, go to Site settings, and under the look and feel section you select “Master Page”
HEre you can assign your new master page with the website.
If “Master Page” does not exist in the “Look and feel” list, then under the Site Collection Administration, click on the Site Colleciton Features, and ensure that “Office Sharepoint Server Publishing Infrastructure” is active.
admin | 4:02 pm | November 6, 2007 | Joomla
If you move domains and need to update all the hyper links within your site do this:
update `mos_content` set `fulltext` = REPLACE(`fulltext`,’snowskool.co.uk’,’snowskool.com.au’);
and then
update `mos_content` set `introtext` = REPLACE(`introtext`,’snowskool.co.uk’,’snowskool.com.au’)
Note: mos_content may be swapped with jos_content (we originally installed mambo)
admin | 3:50 pm | | phpbb
Errors like that generally mean there’s an issue with the auto_increment attribute on that table. However, since this is a search table, it’s not very important for a restore. Search tables take up about 1/3 of the backup, and are rebuildable. Since they are rebuildable, it’s better to remove them from the backup so you can restore it much more quickly.
The following tables can be removed from the backup:
phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch
This includes the CREATE and INSERT lines for those tables. Remove any lines in your backup that start with this:
INSERT INTO phpbb_search_results
INSERT INTO phpbb_search_wordlist
INSERT INTO phpbb_search_wordmatchOnce your board is restored, you can use this MOD to rebuild the search tables: Rebuild Search
In my situation, the cms system in the database was important, not the forum so I didnt use the Mod to rebuild the search.