BcStorm Client Error

[StreetMoney]

Hi Guys When ever i load up my client it shows me this error

You must be registered for see images attach

Anyone? 
Anyone Can help me Pleasee

 

[danbenson93]

go into your user database and scroll to the right, if your user has any NULL values on the right then this will be causing the error, set a default value for them and then edit your users NULL columns with the default value you have set.

Let me know if you still have this problem.

 

[StreetMoney]

go into your user database and scroll to the right, if your user has any NULL values on the right then this will be causing the error, set a default value for them and then edit your users NULL columns with the default value you have set.

Let me know if you still have this problem.

Ok so do i do ctrl+D To edit nulls? And what value do i put it on 1 or 0 ?

 

[danbenson93]

please comment what NULL's are appearing first please before I can give you the answer

 

[StreetMoney]

For somereason im getting this error while importing database

[Err] 1265 - Data truncated for column 'visible' at row 1

 

[danbenson93]

Hmm, find column visible and edit its character length as I think that error means that more characters are being inputted than what the column is designed e.g varchar could be 250 and its trying to import 251 into that column.

Just edit the value of the visible column and see if the error happens

 

[StreetMoney]

This what it shows see

[SQL]
INSERT INTO `catalog_pages` VALUES ('134', '91', 'System', '0', '1', '', '', '7', '0', '0', '100', 'default_3x3', 'catalog_frontpage_headline2_en', 'catalog_limited_teaser_en', '', '', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
[Err] 1265 - Data truncated for column 'visible' at row 1

 

[danbenson93]

add value 1 for visible in the catalog_pages table, this should fix the error

 

[StreetMoney]

It already has 1

 

[danbenson93]

erm, try setting it to empty string then. as your sql might contain values of 0 and 1

 

[lee1418]

everytime I load the hotel an once i get on hotelview it d/cs instantly