ImportError: __import__ not found when using Server Script on Stock Entry (Frappe v15.69.2)

ERPNext
,
1

Hi all — I’m running ERPNext (v15.63.0) and Frappe (v15.69.2) on a self-hosted server.

I’m using a Server Script of type Document Event on Stock Entry, set to trigger After Submit.

Even with only this code

import frappe
from datetime import datetime
frappe.log_error(“Test Script”, “Running”)

I am getting this error on submit…

ImportError: import not found
Possible source of error: Server Script

I have verified:
• Only one script is active
• It’s not disabled
• Other scripts without imports work fine

Is this expected in Frappe v15.69.2? Is there a setting, patch, or known workaround to allow basic imports like datetime?

Thanks in advance.

2

Server script and other places where dynamic code is loaded and executed…use safe_exec or safe_eval… that restrict the global available in the context… this is security thing…

3

Thanks — that makes sense.

To follow up, I’ve rewritten my Server Script to remove all import statements and avoided using frappe.cache() or frappe.generate_hash().

I’m now using only:
frappe.utils.now_datetime()
frappe.get_all(“Serial No”, filters=…, limit=…)

The script executes cleanly (no ImportError), but now I’m getting a SQL syntax error when calling frappe.get_all() inside the Server Script:

ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘’‘\n\n order by tabSerial No.modified DESC’ at line 3”)

Even running this query directly in bench console throws the same error:

Any idea why this is happening? The filters seem clean, and Serial No definitely has a uid field that is nullable. Could this be due to a missing default value or quoting issue in MariaDB?

Appreciate any insights.

4

I suggest you get it working in System Console first…You can use a denug=True flag there, and maybe get an idea from the query… try something like this in System Console… I can’t see your filters, though it’s unlikely to cause a problem

image
image2750×658 42.8 KB

5

here is the script I ran in system console. below that is the output.

serial_no = “MOD-SRL-YYMMDD-0002”

sn = frappe.get_doc(“Serial No”, serial_no)
item_code = sn.item_code
warehouse = sn.warehouse or frappe.db.get_value(
“Stock Ledger Entry”,
{“serial_no”: serial_no},
“warehouse”
)
printer_ip = frappe.db.get_value(“Warehouse”, warehouse, “custom_printer_ip”)
timestamp = sn.creation.strftime(“%m/%d/%Y %H:%M”)

zpl = f"“”^XA
^FO40,40^BQN,2,5^FDLA:{serial_no}^FS
^FO40,250^A0N,30,30^FDItem: {item_code}^FS
^FO40,300^A0N,30,30^FDSN: {serial_no}^FS
^FO40,350^A0N,25,25^FDRecv: {timestamp}^FS
^XZ"“”

import requests
r = requests.post(f"http://{printer_ip}", data=zpl, headers={“Content-Type”: “text/plain”})
r.status_code

output with error -

Traceback (most recent call last):
File “apps/frappe/frappe/desk/doctype/system_console/system_console.py”, line 32, in run
safe_exec(self.console, script_filename=“System Console”)
File “apps/frappe/frappe/utils/safe_exec.py”, line 114, in safe_exec
exec(
File “: system_console”, line 11, in
KeyError: ‘import’

all we are trying to do is print to a local printer using API