Bablosoft

importing csv to database with colons and breaklines : in it

Support

  • loclan6879L

    How to make multiple computers work on the same BAS database???

    Support
    0 Votes
    4 Posts
    1120 Views
    sergerdnS

    @loclan6879 said in How to make multiple computers work on the same BAS database???:

    @morpheus93 but my sql to dificult to use. i need db orginal of BAS. Can i???

    Using a database in any software is a common practice in development. I don't see any difficulties here.

    In any case, you don't have many options except to set up a database server on your local network, like MongoDB, MySQL, or something similar, and then connect your script to that database server.

    Another approach is to implement web app with an API for CRUD operations, such as Swagger, and create a simple BAS module to manipulate account data during registration or similar tasks. I use this method very often because it simplifies BAS coding, as all logic is implemented in the web app.

  • P

    What is the quickest way to extract data from a single column on Database ?

    Support
    0 Votes
    1 Posts
    575 Views
    No one has replied
  • M

    Resource and database settings are removed

    Support
    0 Votes
    2 Posts
    648 Views
    M

    Now I am faced with the problem that after trying to add a Database to a new project by ID, all the data and tables were deleted from it

  • E

    how to fix failed to run database

    Support
    0 Votes
    5 Posts
    1329 Views
    I

    Спасибо за ссылки на похожую тему, но к сожалению мне не помогло, возможно я, что то делаю не так. Удаление mongod.lock действительно убрало надпись вначале об ошибке, но базы не работают. Переустановка BAS тоже не решила проблему.

    @Fox said in Глюкнула БД прошу подсказать:

    @dobrok said in Глюкнула БД прошу подсказать:

    @UserTrue said in Глюкнула БД прошу подсказать:

    @dobrok я с таким не сталкивался

    Ни одна из БД не работает, даже новую создаю, после перезагрузки не коннект.

    Удалите файл C:\Users%USERNAME%\AppData\Local\BasDatabases\НАЗВАНИЕ БАЗЫ\current\mongod.lock Запустите mongod --dbpath C:/Users/%USERNAME%/AppData/Local/BasDatabases/НАЗВАНИЕ БАЗЫ/ --repair. mongod есть в папке с BAS.

    Данный метод сделал с помощью командной строки, получив вот это:

    PS C:\Users\ilyaa> C:\Users\ilyaa\AppData\Roaming\BrowserAutomationStudio\apps\24.7.1\mongod.exe --dbpath C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket/ --repair
    2022-03-14T17:45:25.775+0300 [initandlisten] MongoDB starting : pid=34756 port=27017 dbpath=C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket 64-bit host=DESKTOP-A70S6NA
    2022-03-14T17:45:25.775+0300 [initandlisten] targetMinOS: Windows 7/Windows Server 2008 R2
    2022-03-14T17:45:25.775+0300 [initandlisten] db version v2.6.6
    2022-03-14T17:45:25.775+0300 [initandlisten] git version: 608e8bc319627693b04cc7da29ecc300a5f45a1f
    2022-03-14T17:45:25.775+0300 [initandlisten] build info: windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49
    2022-03-14T17:45:25.775+0300 [initandlisten] allocator: system
    2022-03-14T17:45:25.775+0300 [initandlisten] options: { repair: true, storage: { dbPath: "C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket/" } }
    2022-03-14T17:45:25.838+0300 [initandlisten] finished checking dbs
    2022-03-14T17:45:25.838+0300 [initandlisten] dbexit:
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to close listening sockets...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to flush diaglog...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to close sockets...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: waiting for fs preallocator...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: closing all files...
    2022-03-14T17:45:25.838+0300 [initandlisten] closeAllFiles() finished
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: removing fs lock...
    2022-03-14T17:45:25.838+0300 [initandlisten] dbexit: really exiting now
    PS C:\Users\ilyaa>

    Но базы не заработали. Если же просто запустить отдельно файл mongod.exe, то увидим:

    C:\Users\ilyaa\AppData\Roaming\BrowserAutomationStudio\apps\24.7.1\mongod.exe --help for help and startup options
    2022-03-14T18:02:16.828+0300 [initandlisten] MongoDB starting : pid=39768 port=27017 dbpath=\data\db\ 64-bit host=DESKTOP-A70S6NA
    2022-03-14T18:02:16.843+0300 [initandlisten] targetMinOS: Windows 7/Windows Server 2008 R2
    2022-03-14T18:02:16.843+0300 [initandlisten] db version v2.6.6
    2022-03-14T18:02:16.843+0300 [initandlisten] git version: 608e8bc319627693b04cc7da29ecc300a5f45a1f
    2022-03-14T18:02:16.843+0300 [initandlisten] build info: windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49
    2022-03-14T18:02:16.854+0300 [initandlisten] allocator: system
    2022-03-14T18:02:16.863+0300 [initandlisten] options: {}
    2022-03-14T18:02:16.863+0300 [initandlisten] exception in initAndListen: 10296

    ERROR: dbpath (\data\db) does not exist.
    Create this directory or give existing directory in --dbpath.
    See http://dochub.mongodb.org/core/startingandstoppingmongo

    , terminating
    2022-03-14T18:02:16.863+0300 [initandlisten] dbexit:
    2022-03-14T18:02:16.863+0300 [initandlisten] shutdown: going to close listening sockets...
    2022-03-14T18:02:16.868+0300 [initandlisten] shutdown: going to flush diaglog...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: going to close sockets...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: waiting for fs preallocator...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: lock for final commit...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: final commit...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: closing all files...
    2022-03-14T18:02:16.870+0300 [initandlisten] closeAllFiles() finished
    2022-03-14T18:02:16.870+0300 [initandlisten] dbexit: really exiting now

    [процесс завершил работу с кодом 100 (0x00000064)]

  • G

    "à" "é" "ê" not supported when import from lines is used

    Support
    0 Votes
    1 Posts
    907 Views
    No one has replied