error while using mysql2 with Nextjs latest app directory?

[Nithur-M]

This is the error:
TypeError: LRU is not a constructor
Does anyone know what I am doing wrong or how to resolve it?
Thanks.

[Nithur-M]

Hello @sidorares, any thoughts on this?

[sidorares]

Can you give a bit more information? Version of mysql2 package installed, stack trace for the error

[Nithur-M]

I am using mysql 3.2.0, and the error seems to come from the lru-cache package.

[Nithur-M]

Here is the complete stack trace:

Server Error
TypeError: LRU is not a constructor

This error happened while generating the page. Any console logs will be displayed in the terminal window.
Call Stack
eval
node_modules\mysql2\lib\parsers\parser_cache.js (5:20)
(sc_server)/./node_modules/mysql2/lib/parsers/parser_cache.js
file:///C:/Users/ADMIN/Desktop/project/.next/server/app/page.js (1587:1)
__webpack_require__
file:///C:/Users/ADMIN/Desktop/project/.next/server/webpack-runtime.js (33:42)
require
node_modules\mysql2\lib\parsers\text_parser.js (7:20)
(sc_server)/./node_modules/mysql2/lib/parsers/text_parser.js
file:///C:/Users/ADMIN/Desktop/project/.next/server/app/page.js (1609:1)
__webpack_require__
file:///C:/Users/ADMIN/Desktop/project/.next/server/webpack-runtime.js (33:42)
require
node_modules\mysql2\lib\commands\query.js (10:22)
(sc_server)/./node_modules/mysql2/lib/commands/query.js
file:///C:/Users/ADMIN/Desktop/project/.next/server/app/page.js (1103:1)
__webpack_require__
file:///C:/Users/ADMIN/Desktop/project/.next/server/webpack-runtime.js (33:42)
require
node_modules\mysql2\lib\commands\index.js (5:14)

[rildomar]

i'm having the same error.. but i dont have installed mysql on package.json..

any solution?

[wellwelwel]

@rildomar, you can check who is using the LRU-Cache by running npm ls lru-cache 🙋🏻‍♂️