Step -1
Drop table WebShop if it exists (and all starting with WebShop_bla_bla)
Drop table MEMB_CREDITS if it exists -> NOTE: All credits data will be DELETED!
Delete stored procedure XCredits if it exists ->(Or just Modify it)
Step -2
Put in New Query this 4 scripts
Nop, not work... the first and second script have error...
first script:
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
second script:
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'WebShop_IPBlock' has been created but its maximum row size (8116) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
"No items for sale." appear
I use SQL 2000 and files Darksteam ultimate update