Showing questions tagged: Show all questions
  • Locked

Firefox crashes

Question duplicated. Continue at https://support.mozilla.org/en-US/questions/1283685 bp-68678548-283c-46c6-b6c3-0658c0200406 4/5/2020 9:25 PM bp-ae84e06b-fb5d-4d63-832c-6… (read more)

Question duplicated. Continue at https://support.mozilla.org/en-US/questions/1283685

bp-68678548-283c-46c6-b6c3-0658c0200406 4/5/2020 9:25 PM bp-ae84e06b-fb5d-4d63-832c-6a7350200404 4/4/2020 1:24 AM bp-d914610a-de60-4397-b020-7e5d70200321 3/21/2020 3:18 AM bp-3f98246e-de18-4ba1-ae78-451580200320 3/20/2020 3:10 AM bp-6815b058-5698-4c99-9469-854920200302 3/1/2020 9:49 PM bp-f710766b-0469-4145-a922-6c84b0200118 1/17/2020 10:55 PM bp-f1fab83f-ba47-4bd8-a146-018bd0200117 1/16/2020 9:44 PM bp-cf14fc41-e18f-4104-8671-656fa0191222 12/22/2019 2:09 PM bp-08275a02-c1ac-40bd-a883-4be4b0191221 12/21/2019 2:54 PM bp-dc85365f-7e53-4b4e-aae3-e58450191220 12/19/2019 10:00 PM

Asked by gcarlse 2 months ago

  • Locked

i have problem whith google keep site

i have one note from google keep site, which work very very slowly, but google chrome no problem... Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE Good… (read more)

i have one note from google keep site, which work very very slowly, but google chrome no problem...

Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE GoodID=251

дубли товаров по алкокоду (каталог 2) SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

дубли партнеров по ФСРАР id (карта) SELECT * FROM partners WHERE CardNumber In (SELECT CardNumber FROM Partners WHERE CardNumber <> AND ID > 1 GROUP BY CardNumber HAVING COUNT(CardNumber) > 1) ORDER BY CardNumber

дубли считанных марок (mssql) SELECT * FROM InternalLog WHERE Message In (SELECT Message FROM InternalLog WHERE Message like '%UTM_%' GROUP BY Message HAVING COUNT(Message ) > 1)

дубли считанных марок (access) SELECT * FROM InternalLog WHERE CStr(Message) LIKE '%UTM_%' AND CStr(Message) In (SELECT CStr(Message) FROM InternalLog WHERE CStr(Message) <> GROUP BY CStr(Message) HAVING COUNT(CStr(Message)) > 1)

Замена товаров в операциях UPDATE Operations SET GoodID='ИД товара который нужно оставить' WHERE GoodID='ИД товара который убираем'

выбор только пивной продукции Select * From goods where Ltrim(Rtrim(substring(goods.catalog3, 178, 15))) in (261,262,263,500,510,520)

select * from goodsgroups where code like 'aab%'

SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

SELECT * FROM Goods WHERE IsNumeric(Barcode1)=0 AND Barcode1<> SELECT * FROM Goods WHERE IsNumeric(Code)=0 AND Code<>

update operations set userrealtime = userrealtime -1 WHERE...

update operations set userrealtime = date + convert(nvarchar(8),userrealtime,114) WHERE ...

А что может быть проще? Insert [ИМЯ НОВОЙ БАЗЫ].[dbo].[partners] ([Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays]) (Select [Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays] from [ИМЯ СТАРОЙ БАЗЫ].[dbo].[Partners])

Server1 - 1000-2499.99 => 4% UPDATE p SET Discount = 4 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 1000 AND paym.TurnoverSum < 2500

Server2 - 2500+ => 5% UPDATE p SET Discount = 5 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 2500


разные цены

Select * from operations o2 where goodid in (select distinct goodid from operations o left join goods g2 on g2.id = o.goodid where o.Priceout <> g2.priceout2) SELECT * FROM partners WHERE TaxNo = AND CardNumber not like '%050000%' AND CardNumber <>


Александр, вот триггер: USE [vd3] GO /***** Object: Trigger [dbo].[PaymentTypesByUsers] Script Date: 08/14/2017 07:36:40 *****/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create Trigger [dbo].[PaymentTypesByUsers] ON [dbo].[Payments] AFTER INSERT

AS

IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) = 6 and not (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) in (1,2,3,4,5) and (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end

триггер в Payments на запрет видов оплаты в зависимости от партнера


DELETE FROM ApplicationLog DELETE FROM CashBook DELETE FROM CurrenciesHistory DELETE FROM Documents DELETE FROM ECRReceipts DELETE FROM InternalLog DELETE FROM Lots where id > 1 DELETE FROM Network DELETE FROM NextAcct DELETE FROM Operations Where OperType NOT IN (20,21) DELETE FROM Payments DELETE FROM Transformations DELETE FROM Store

Эту выполнять после всех. DELETE FROM Goods WHERE ID NOT IN (SELECT DISTINCT GoodID FROM Operations)

UPDATE Partners SET Phone2=Phone WHERE NOT Phone=Phone2 AND ID>1 В шедулер

операции без товара: select goodid from operations where goodid > 0 and goodid not in (select distinct id from goods)

DECLARE @CashbookID as int DECLARE @ObjectID as int DECLARE @Acct as int DECLARE Acct_Cursor CURSOR local FOR SELECT ID FROM cashbook where SUBSTRING([Desc],13,10) IN (SELECT DISTINCT Acct FROM payments where opertype = 2) OPEN Acct_Cursor

FETCH NEXT FROM Acct_Cursor into @CashbookID
WHILE @@FETCH_STATUS = 0 
IF @@FETCH_STATUS = 0 
BEGIN
 SET @Acct = (SELECT SUBSTRING([Desc],13,10) FROM cashbook WHERE ID = @CashbookID)
 SET @ObjectID = (SELECT TOP(1) ObjectID FROM payments WHERE acct = @Acct)
 UPDATE cashbook SET ObjectID = @ObjectID WHERE ID = @CashbookID
 FETCH NEXT FROM Acct_Cursor into @CashbookID;
END
ELSE 
 CLOSE Acct_Cursor
 DEALLOCATE Acct_Cursor

Привет! Подскажите пожалуйста, как поправить таблицу CashBook, поле ObjectID? Нужно привести в соответствии с таблицей Operations или Payments. БД MSSQL 2012



дата из примечания

обновит все строки, где в примечании есть слово ЕГАИС

MSSQL:

update operations set date = cast(convert(datetime, SUBSTRING(Note, 7, 10), 104) as date) where note like 'ЕГАИС%' and opertype = 1

ACCESS:

________________

it isn't all

v.s. -->

Asked by 5978156 2 months ago

  • Locked

Firefox installed by snap: how to open downloaded files?

locking this thread as duplicate, please continue at https://support.mozilla.org/en-US/que.../1284465 Firefox came preinstalled as snap package on ubuntu 18.04, but has … (read more)

locking this thread as duplicate, please continue at https://support.mozilla.org/en-US/que.../1284465

Firefox came preinstalled as snap package on ubuntu 18.04, but has been giving trouble since

I'm running through problems when downloading files:


   The open with dialog application does not see most applications, in particular it doesn't see evince nor libreoffice. The dropdown defaults to "Url Handler Script (default)", which does nothing with my files.
If I choose to open the file with firefox (say a pdf file) a blank page appears

All these options work with chrome though..

The only way I can view a downloadable file is by saving it somewhere in my home directory and then open it which is a pain!


Obviously snap firefox doesn't access anything beyond thatI've successfully installed Firefox as a snap package (done by default by installing it through Ubuntu's "software center"). It does work, and give me a more recent version of Firefox than the one available through APT.

I'm running through problems when downloading files, though:

   Saving them in /tmp/ does not work, since the snap version of Firefox uses a different filesystem than the one of the host computer, hence Firefox and non-snap applications see different content in /tmp/.
   The open with dialog application does not see most applications, in particular it doesn't see evince nor libreoffice, which I've installed through APT. The dropdown defaults to "Url Handler Script (default)", which apparently does nothing with my files.
   If I save a downloaded file, the open containing folder button in the downloads list does not work. I'm guessing that it tries to open nautilus, but fails to do so because nautilus is a non-snap application.I've successfully installed Firefox as a snap package (done by default by installing it through Ubuntu's "software center"). It does work, and give me a more recent version of Firefox than the one available through APT.

I'm running through problems when downloading files, though:

   Saving them in /tmp/ does not work, since the snap version of Firefox uses a different filesystem than the one of the host computer, hence Firefox and non-snap applications see different content in /tmp/.
   The open with dialog application does not see most applications, in particular it doesn't see evince nor libreoffice, which I've installed through APT. The dropdown defaults to "Url Handler Script (default)", which apparently does nothing with my files.
   If I save a downloaded file, the open containing folder button in the downloads list does not work.

Asked by chet10 2 months ago

  • Locked

Firefox crashes a few minutes after opening

locking this thread as duplicate, please continue at https://support.mozilla.org/en-US/que.../1284801 Both Firefox and Chrome aren’t staying open for more than a few minu… (read more)

locking this thread as duplicate, please continue at https://support.mozilla.org/en-US/que.../1284801

Both Firefox and Chrome aren’t staying open for more than a few minutes. No matter what site I have open or however many tabs they crash. My other apps are working, my internet is stable as well as my hardware. I’ve already restarted the computer, uninstall and reinstalled Firefox, cleaned my temp folders, cleaned up my disk and cleared my browser history. Latest report ID: bp-1322df80-2a8e-4e2d-9212-ff0030200417

Asked by clarksimon 2 months ago

  • Locked

Firefox crashes

2020年に入り、firefoxが頻繁にクラッシュようになりました。 『firefox』『Windows』『ドライバー』『セキュリティソフト』それぞれの更新は問題なし セーフモードでも頻繁にクラッシュが発生いたします。 firefoxのリフレッシュを行い、ブックマークやプラグインなども見直しましたが 改善されません。 また、同PC上の別ブ… (read more)

2020年に入り、firefoxが頻繁にクラッシュようになりました。

『firefox』『Windows』『ドライバー』『セキュリティソフト』それぞれの更新は問題なし セーフモードでも頻繁にクラッシュが発生いたします。 firefoxのリフレッシュを行い、ブックマークやプラグインなども見直しましたが 改善されません。 また、同PC上の別ブラウザ(chromeなど)ではクラッシュなどの問題は発生いたしません。

解決策がございましたら、ご教授いただけますと幸いです。

クラッシュ ID: bp-9df6cbf6-acbc-4b8a-8cad-7575d0200418


duplicated. continue at https://support.mozilla.org/questions/1284866

Asked by maru9_the_fool 2 months ago

  • Locked

Firefox desktop browser stuck on endless launch loop

To start, I am using Windows 10 and Firefox 75.0. I have recently reinstalled Firefox and have run into a problem that makes the program unusable. When launching the brow… (read more)

To start, I am using Windows 10 and Firefox 75.0. I have recently reinstalled Firefox and have run into a problem that makes the program unusable. When launching the browser after installation, it will never open and instead get stuck endlessly closing and opening a process in task manager. It is also not possible to terminate the process without either restarting my computer or uninstalling, as it will give an error saying the process does not exist anymore. This also seems to open and close consent.exe in the system32 files endlessly. I've tried multiple previous versions of Firefox in order to try and mitigate this problem, but all of them encounter the same result. I've uninstalled, deleted all of my profiles, cleared all files in appdata, and even tried deleting registry files related to the browser, but the problem persists. A similar problem seems to have been encountered by another user, but their problem seemed to fix itself (https://bugzilla.mozilla.org/show_bug.cgi?id=1589424). Firefox also doesn't seem to produce any errors with this issue, so I am unsure of what to do.

EDIT: As of this writing I figured out the problem. It turns out my user account control panel had been disabled and was trying to launch itself to verify permissions. My user account did not have full control over the application, hence UAC trying to activate. Changing my account permissions solved this problem.

Asked by dylanmccy 2 months ago

  • Locked

I can't login paypal page with firefox 75.0 64 bit

duplicated. Continue at https://support.mozilla.org/en-US/questions/1285229 I can't login paypal page with firefox 75.0 64 bit, I've reinstalled the firefox. and clear co… (read more)

duplicated. Continue at https://support.mozilla.org/en-US/questions/1285229

I can't login paypal page with firefox 75.0 64 bit, I've reinstalled the firefox. and clear cookies but nothing help. When l login paypal with my email then paypal popup the security challenge page

I need entry the security code. but I can't get the code It always shows like the following.

Secure Connection Failed The connection to the server was reset while the page was loading. The page you are trying to view cannot be shown because the authenticity of the received data could not be verified.

   Please contact the website owners to inform them of this problem.

Asked by hoyt9901 2 months ago

  • Locked

How do I stop the accumulation of tabs' history in: History > Recently Closed Tabs?

Locking this thread.Please continue here: [/questions/1285975] Using an Apple computer and Firefox 75.0 ... In in my toolbar (where the File, Edit, View options are), and… (read more)

Locking this thread.
Please continue here: [/questions/1285975]
Using an Apple computer and Firefox 75.0 ... In in my toolbar (where the File, Edit, View options are), and I go to History > Recently Closed Tabs ... I see many recently opened tabs listed. How do I stop "Recently Closed Tabs" from accumulating? I want that list to always be clear.

Thank you.

Asked by brightonbeach1930 2 months ago

  • Locked

Twitter not loading - cookie issue?

I'm using a completely clean (reinstalled) version of firefox. I'm not logged into a profile. I'm still having the same problem. If I go onto twitter for the first time, … (read more)

I'm using a completely clean (reinstalled) version of firefox. I'm not logged into a profile. I'm still having the same problem.

If I go onto twitter for the first time, it loads fine and I can move around pages.

As soon as I leave the site, then return, none of the internal twitter timelines load - I get the twitter message 'something has gone wrong'.

If I delete all my cookies and revisit twitter, it works. But again, if I leave the site and come back immediately, the problem comes back and nothing loads.

Anyone experienced this/know what I can do?

Thanks

duplicate. https://support.mozilla.org/en-US/questions/1286675

Asked by Tom 1 month ago

  • Locked

firefox crashed and i lost all 150 or so tabs i had open they were in 4 windows restor windows was empty and sow was restor tabs this happend yesterday

firefox crashed and i lost all 150 or so tabs i had open they were in 4 windows restore windows was empty and sow was restore tabs this happened yesterday can someone hel… (read more)

firefox crashed and i lost all 150 or so tabs i had open they were in 4 windows restore windows was empty and sow was restore tabs this happened yesterday can someone help restore from beginning from the start of yesterday may 16

duplicate. https://support.mozilla.org/en-US/questions/1287220

Asked by mickeymousenb 1 month ago

  • Locked

treats

Any chance you guys could help me with a shopping list I have as it's the first time I have been able/ allowed to try myself to treat myself. Thank you very much and I w… (read more)

Any chance you guys could help me with a shopping list I have as it's the first time I have been able/ allowed to try myself to treat myself. Thank you very much and I would appreciate very much thank

Asked by coleentait1 1 month ago

  • Locked

treats

Hey again guys just wondering if you can help me yet, am going threw a rough ride can do with something to make things just a bit more bareable cheers guys am desp or wou… (read more)

Hey again guys just wondering if you can help me yet, am going threw a rough ride can do with something to make things just a bit more bareable cheers guys am desp or wouldn't be asking right out like this xx

Asked by coleentait1 1 month ago