5.2.14 update broked printing!

pipneogen · December 9, 2018, 3:51pm

After update from 5.2.12 to 5.2.14 our printing is broked! How to fix it?

pipneogen · December 9, 2018, 4:36pm

Pls help me, I cant to downgrade DB version (from 148 to 145) and our work was stopped!

Jesse · December 9, 2018, 4:39pm

Ticket printing? What were you doing when you got that error

pipneogen · December 9, 2018, 4:43pm

With all ticket printing issues - preview template or printing.

In 5.2.12 version all was ok, after update to 5.2.14 I had this error!

Ticket template example:

[LAYOUT]
<div style="font-size:12px;font-family:Calibri">
<table>
<tr>
<td width=130 align=Left>Bar order</td> <td width=90 align=Right>{TICKET TIME}</td>
</tr>
<tr>
<td width=130 align=Left>Time:</td> <td width=90 align=Right>{TICKET TIME}</td>
</tr>
<tr>
<td width=130 align=Left>Date:</td> <td width=90 align=Right>{TICKET DATE}</td>
</tr>
<tr>
<td width=130 align=Left>Waiter:<td> <td width=90 align=Right>{USER NAME}</td>
</tr>
<tr>
<td width=130 align=Left>{TICKET TYPE} No:</td> <td width=90 align=Right>{TICKET NO}</td>
</tr>
</tr>
<tr>
{ENTITIES}
</tr>

<tr>
<td width=200 align=Left>{NOTE}</td>
</tr>

</table>
</div>

<div style="font-size:11px;font-family:Calibri;font-weight:bold">

<table>
<tr>
<td width=130 align=Left>NAME</td>|<td width=80 align=Right>QTY</td>
</tr>
</table>

</div>

<div style="font-size:12px;font-family:Calibri;font-weight:bold">
<table>

{ORDERS}
</table>
</div>

[ORDERS GROUP|ORDER TAG:Курсы подачи]
<tr>

<td width=130>–=={GROUP KEY}==–</td>

</tr>

[ORDERS]
– Default format for orders

<tr>

<td width=130>{NAME}</td><td width=80 align=Right> -{QUANTITY}-</td>

</tr>

{ORDER TAGS}

[ORDERS:Gift]
– Format for gifted orders
<tr>
<td width=158>- {QUANTITY} {NAME} </td><td width=30>{PRICE}</td><td width=30> GIFT</td>
</tr>

[ORDERS:Void]
– Nothing will print for void lines
<tr>
<td width=158>{NAME}</td><td width=64 align=Right>-{QUANTITY}-VOID</td>
</tr>

{ORDER TAGS}

[ORDER TAGS:General Modifiers]
– Format for order tags

<tr>
<td width=160> *{ORDER TAG QUANTITY} x {ORDER TAG NAME}</td>
</tr>

[ORDER TAGS:Portion modificators]
– Format for order tags

<tr>
<td width=160> *{ORDER TAG QUANTITY} x {ORDER TAG NAME}</td>
</tr>

[ORDER TAGS:Прожарка]
– Format for order tags

<tr>
<td width=160> *{ORDER TAG QUANTITY} x {ORDER TAG NAME}</td>
</tr>

[ENTITIES:Table]
– Table entity format
<tr>
<td width=130 align=Left>СТОЛ НОМЕР:{ENTITY NAME}</td> <td width=90 align=Right>КОЛ-ВО ГОСТЕЙ:{TICKET TAGN:Person Count}</td>
</tr>

[ENTITIES:Customer]
– Customer entity format
<tr>
<td width=60>Customer/სტუმარი:{ENTITY DATA:Name} <td width=180>{ENTITY NAME}</td>
</tr>

<tr>
<td width=60>Tel/ტელ:</td> <td width=180>{ENTITY DATA:Phone}</td>
</tr>
<tr>
<td width=60>Address/მისამართი:</td> <td width=180>{ENTITY DATA:Address} </td>
</tr>

<tr>
<td width=60>Tarif/ტარიფი:</td> <td width=180>{ENTITY DATA:Tarif} </td>
</tr>

Jesse · December 9, 2018, 4:45pm

So your using html printer. Check printer settings?

pipneogen · December 9, 2018, 4:47pm

Everything is as it was, printers are configured as HTML. I did not change anything, only updated version of the program.

Jesse · December 9, 2018, 4:48pm

I’ve not seen that error. I use html printers as well. I upgraded no issues on mine so have others. We need to figure out what it is.

pipneogen · December 9, 2018, 4:49pm

I am glad that I will help the development of the program, but what should I do now? When I try to return the old version I have nothing. How do I get back to 5.2.12?

Jesse · December 9, 2018, 4:49pm

Never upgrade live system during live operation that’s just not smart. Did you backup before upgrade?

pipneogen · December 9, 2018, 4:51pm

Yes, I made it. I tried to restore in 5.2.14 version, because 5.2.12 version doesn’t work ("check db version 148-145) and it doesn’t work.

Jesse · December 9, 2018, 4:52pm

You need to uninstall then reinstall 5.2.12 and use mssms to restore your backup. Or restore your backup after 5.2.12 install

pipneogen · December 9, 2018, 4:53pm

I did it. I’m trying to recover from a file, but when I launch the program, I write that version 148 is still.

If I’m trying to open in 5.2.12 version, program show me the error: “check db version”

Jesse · December 9, 2018, 4:58pm

You can only load a backup that was made in 5.2.12

You uninstalled and are now in 5.2.12 right?

pipneogen · December 9, 2018, 5:01pm

Yes, but I can’t to open my DB after restore, because DB version don’t changed to 145

Jesse · December 9, 2018, 5:01pm

What version of sql server?

pipneogen · December 9, 2018, 5:02pm

14.0.1000 SQL express

Jesse · December 9, 2018, 5:02pm

Reason you can’t open it is because it was made on a different version.

Jesse · December 9, 2018, 5:02pm

So sql server express 2017?

pipneogen · December 9, 2018, 5:04pm

Yes, and I tried to restore from backup which I made in 5.2.12 version, and it doesn’t work. I have no idea, why.

Jesse · December 9, 2018, 5:05pm

The reason why is that you didn’t make it while in the version your currently running. It’s saying it’s not the right version. So either your sambapos is not 5.2.12 or the backup was not made in 5.2.12