Ok, let's cheat. You have very few rules, and most of the info has been
moved already. So just comment the lines 20734 to 20746 and run
updatedatabase.pl again.
OR modify the version to move ahead.
update systempreferences set value = '19.1200018' where variable =
'version';
Then you can drop the issuingrules table later, when you're satisfied
with everything. Note that you'll need to update the rules manually in
the staff interface to add back the issue length and renewal count/period...
Logo inLibro <https://inLibro.com> Philippe Blouin
Directeur de la technologie
T 833-INLIBRO (465-4276) <tel:833-465-4276>, poste 230
C philippe.blo...@inlibro.com
www.inLibro.com <https://inLibro.com>
On 2024-07-10 08:10, Michael Kuhn wrote:
Hi Philippe
You wrote:
> updatedatabase.pl line 20736
>
> It's the conversion from issuingrules to circulation_rules. What's the
> state of your DB right now? Has it started to convert?
The script stopped just after giving the shown message.
> How many circ rules already created? I suspect it's 0, but it's worth
> asking.
In the database I find 13 rules:
MariaDB [koha_bib]> select * from circulation_rules;
+----+------------+--------------+----------+-------------------+------------+
| id | branchcode | categorycode | itemtype | rule_name |
rule_value |
+----+------------+--------------+----------+-------------------+------------+
| 2 | NULL | NULL | NULL | refund | 1 |
| 16 | NULL | DIENST | NULL | maxissueqty | 9999
|
| 17 | NULL | DIENST | NULL | maxonsiteissueqty | 9999
|
| 18 | NULL | ARCHIV | NULL | maxissueqty | 200
|
| 19 | NULL | ARCHIV | NULL | maxonsiteissueqty | 200
|
| 20 | NULL | ARCHBE | NULL | maxissueqty | 50
|
| 21 | NULL | ARCHBE | NULL | maxonsiteissueqty | 50
|
| 22 | NULL | ARCHPR | NULL | maxissueqty | 200
|
| 23 | NULL | ARCHPR | NULL | maxonsiteissueqty | 200
|
| 26 | NULL | INSTIT | NULL | maxonsiteissueqty | 0 |
| 27 | NULL | INSTIT | NULL | maxissueqty | 0 |
| 28 | NULL | INSTMI | NULL | maxonsiteissueqty | 200
|
| 29 | NULL | INSTMI | NULL | maxissueqty | 200
|
+----+------------+--------------+----------+-------------------+------------+
13 rows in set (0,000 sec)
> Considering the id is an autoincrement, and it not moved from one
> table to the other, I fail to see how you could have two "0"... (even
> one, actually).
The Auto_increment value for table "issuingrules" is NULL:
MariaDB [koha_bib]> SELECT `AUTO_INCREMENT` FROM
INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'koha_bib' AND
TABLE_NAME = 'issuingrules';
+----------------+
| AUTO_INCREMENT |
+----------------+
| NULL |
+----------------+
I'm also sending you the output of "select * from issuingrules" in the
attached file. Maybe it shows something to you that I don't see?
I don't know how to continue with this update?
Best wishes: Michael
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
