Search options (Page 5 of 25)

@ZS6SHB How many characters did the item desc have for the failed purchase orders?

Turn on debug(level2) in config.php and report errors found

Same issue here, only happens where item desc is longer than 50 characters - see screenshot below: reported in mantis

Is this the  result of changing to STRICT_ALL_TABLES:-
File connect_db_mysql.inc & connect_db_mysqli.inc
Line 13

define('SQL_MODE', 'STRICT_ALL_TABLES'); // prevents SQL injection with silent field content truncation

Before:- although supplier description was var(50) it used to truncate longer item desc.
Now as is strict it rejects it

The solution is to change table purch_data `supplier_description` to tinytext, but you have a db change ban until 2.5?

Ok, good.

Even though you have embed the font, you should really add a some additional fonts to your font-family, then if the 1st is unavailable the next in line will be used, etc.

One google font for arabic that's not in that list is Noto Naskh/Kufi Arabic

The font whilst being easy to change, there are other considerations you need to think about:-

Google 'safe web font'

Is your installation local or remote server?
Do you have other users? (Unless the font is available on their PC they may see a different font to you).
You can always use a CDN like 'Google Fonts' if you have reliable internet access.
You can 'embed' the font if you do not have reliable internet access.
Not all fonts are free.
Some fonts appear larger/smaller than other fonts of the same size; so any changes to font-size will have to be redone
The list goes on...

What font do you want to use? Does the font have all the Arabic characters you require in it (not all of them do)?

If you are going to use a web safe font then:-

On line 20 change this:-

font-family: Verdana, Arial, Helvetica;

to for example:-

font-family: Georgia, Verdana, Arial, Helvetica;

There are seven occurrences of 'font-family' in the default css, change the ones you want to: (Careful with the #CC table one; that's the date picker - make sure its readable after changes)

If you want anything other than a web safe font there are additional steps - will need to know where the font is/coming from.

To add to Braath's advice in post #6

Do a backup, look in the 'journal' table, look at the 6th column(event_date) see if any row is 'different' to the other dates, cross check against the 'reference' column(4th column) Different could be date reversed, abnormal year, month, day. You'll notice all dates are in order looking down, so one date may standout from the others?

Note as all your efforts have resulted in 'DATABASE ERROR : cannot add journal entry' there may not be one, but erroneous event_date may be there?

@notrinos, html input type 'datetime-local' should give you a date /time picker and input type 'time' will give you a time picker, fully supported on chrome though other browsers not complete see Can I use...?

I used input type 'color' to get a colour picker for the add watermark modification

This may help?

Looks a lot better, I still think the logout bar needs to be changed... where does the ajax icon appear?(create a backup or another long process to see it)
From what Joe's written above he may make some changes to core default theme so it can be used on ltr AND rtl lang.

@rafat by 'tabs, do you mean the main menu? Sales, Purchases, Items and Inventory, etc?

If so:-

In file
\themes\default\default.css

Line 184

Change this:-

div.tabs {
    padding: 3px 0 0 0;
    background: none transparent scroll repeat 0% 0%;
    white-space: nowrap;
    border-collapse: collapse;
    border-bottom: 1px solid #8cacbb;
}

to this:-

div.tabs {
    padding: 3px 0 0 0;
    background: none transparent scroll repeat 0% 0%;
    white-space: nowrap;
    border-collapse: collapse;
    border-bottom: 1px solid #8cacbb;
    float: right;
}

Do the main menu items need to be reordered so that 'Sales' is on the right and 'Setup' is on the left? I'm not sure how to do that.

@rafat Anything else not aligned correctly? (The logout bar doesn't look quite right to me)
If so:-

In file
\themes\default\default.css - Line 288

Change this:-

.headingtext3 {
    font-weight: bold;
    font-size: 10px;
    color: black;
}

to this:-

.headingtext3 {
    font-weight: bold;
    font-size: 10px;
    color: black;
    text-align: right;
}

And

On Line 163 change this:-

.logoutBarRight {
    text-align: right;
}

to this:-

.logoutBarRight {
    text-align: left;
}

Yes that would be correct:-

C, B, S and L are still to be implemented as stated in post 22

The following will only change the alignment of main menu items

In file
\themes\default\default.css

Line 224

Change this:-

.menu_group_items {
    font-weight: normal;
}

to

.menu_group_items {
    font-weight: normal;
    text-align: right;
}

A work around could be done in css; which theme are you using?

Check File: \lang\installed_languages.inc

That rtl is set:-

'rtl' => true,

@AlfonsoM
Go to Setup->Fiscal Years

Clicking on help in the page will open a popup window showing fiscal years wiki.

Once you have finished there go to Setup->Company Setup to set which fiscal year you are using