Showing questions tagged: Show all questions
  • Locked

adress bar and bookmarks not working

Started yesterday. no response to bookmarks or address bar. Have done refresh. No change. Attempted reinstall. can't download and save latest version. Therefore reluctant… (read more)

Started yesterday. no response to bookmarks or address bar. Have done refresh. No change. Attempted reinstall. can't download and save latest version. Therefore reluctant to uninstall. No problems with MS Edge. Would going back to a restore point help?

duplicate: https://support.mozilla.org/questions/1281691

Asked by john.mills6 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 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 12 hours 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 12 hours 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 1 month 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 1 month ago

  • Locked
  • Archived

Firefox browser won't open

I have uninstalled firefox, shut off my computer, turned it back on, re-installed firefox and tried to right click on the exe program file and run as administrator - noth… (read more)

I have uninstalled firefox, shut off my computer, turned it back on, re-installed firefox and tried to right click on the exe program file and run as administrator - nothing works. Now I am having to use Chrome to browse...yuk. All my bookmarks (TONS) are on FIrefox and I like this browser much better than Chrome or Edge.

HELP

Asked by SusanVC 2 years ago

Last reply by Shadow110 2 years ago

  • Solved
  • Archived

Why does the program crash repeatedly when I try and use Sound Cloud

When I try an use Firefox and upload to Sound Cloud I get this error message repeatedly. This is the error message Description: A problem caused this program to stop in… (read more)

When I try an use Firefox and upload to Sound Cloud I get this error message repeatedly. This is the error message

Description:

 A problem caused this program to stop interacting with Windows.

Problem signature:

 Problem Event Name:	AppHangB1
 Application Name:	firefox.exe
 Application Version:	26.0.0.5087
 Application Timestamp:	52a0d273
 Hang Signature:	2480
 Hang Type:	0
 OS Version:	6.1.7600.2.0.0.768.3
 Locale ID:	4105
 Additional Hang Signature 1:	24807c2c6ae5950716c093e6ea3101ec
 Additional Hang Signature 2:	d24f
 Additional Hang Signature 3:	d24f0b50d76295bae82bda3603c82ab7
 Additional Hang Signature 4:	2480
 Additional Hang Signature 5:	24807c2c6ae5950716c093e6ea3101ec
 Additional Hang Signature 6:	d24f
 Additional Hang Signature 7:	d24f0b50d76295bae82bda3603c82ab7

Asked by doggeral 6 years ago

Answered by jscher2000 6 years ago

  • Solved
  • Archived

64 bit version of Firefox?

Locking duplicate thread. Please continue here: [/questions/921343] Is there a 64 bit version of Firefox? I downloaded what I thought was a 64 bit version, it looks and a… (read more)

Locking duplicate thread.
Please continue here: [/questions/921343]

Is there a 64 bit version of Firefox? I downloaded what I thought was a 64 bit version, it looks and acts the same as Firefox but is called Nightly. Is this the 64 bit version of Firefox?

Asked by bubba070 8 years ago

Answered by Matt Brubeck 8 years ago

  • Locked
  • Archived

Downloading PDFs - why so non-intuitive?

Hello! New Firefox user here, since I got too annoyed with IE crashing. So, I often download PDF documents from the Web. With IE, you get a pop-up that asks you to pick a… (read more)

Hello! New Firefox user here, since I got too annoyed with IE crashing. So, I often download PDF documents from the Web. With IE, you get a pop-up that asks you to pick a location in which to save the download. I like that. But with Firefox, all I can do is download it to some "library" that I can't find on my computer or retrieve the articles from. My two questions:

1. Where is that library? On my computer - where???

2. I want the articles on a flash drive, not in some library. How can I specify to Firefox to save the article on my flash drive or desktop, instead of that library?

Thank you!

Asked by Deanala 6 years ago

Last reply by Diego Victor 6 years ago