Bablosoft

database customization

Locked Moved Support

  • S

    I am getting error in database

    Support
    0 Votes
    4 Posts
    825 Views
    sergerdnS

    @Sytehel said in I am getting error in database:

    @sergerdn do u have a telegram or discord

    Of course, I have Telegram, but I don't provide any assistance to users regarding working with BAS. If you require a script, I recommend hiring someone to create it for you.

  • E

    how to fix failed to run database

    Support
    0 Votes
    5 Posts
    936 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)]

  • Y

    select record from database with DATE filter (earlier than/later than) not working

    Support
    0 Votes
    2 Posts
    890 Views
    Y

    nvm it worked sry

  • M

    How to Avoid Duplicates in Database?

    Support
    1 Votes
    7 Posts
    2279 Views
    BAS Viet NamB

    There are many ways to handle this issue. I'll show you one way.

    For a news website, it's almost impossible for recently added articles to have 100% identical content. Therefore, you just need to compare the latest data added to your database with the data you're checking. If they are 100% identical, then the data has already been added, so you can skip it and check the next piece of data using the same process.

    So, for your request, you can convert the database to a list format, then retrieve the last element corresponding to the latest data added (or you can retrieve the latest data directly from the database if you know how to work with databases). Use Parse CSV string to parse the string into article title and content.

    You can compare the title of the latest article with the title you're checking. If they are 100% identical, then it has already been added to the database. If you want to be more certain, you can also compare the content (although this may not be necessary).

    I hope you understand what I'm saying.

  • A

    Select Database Group ID

    Support
    1 Votes
    25 Posts
    7718 Views
    supportS

    @andykaufseo I didn't read all thread, but here is answer for original question.
    You can insert only to new group, which is created with Create Group action.
    Create Group returns group id, which can be used later inside Insert Record action.

    There will be interface to search/edit/delete groups but later.